Ravi Shankar

Tweaking Apps

Office 2010

How to increase number of worksheets Excel

By Leave a Comment

Microsoft Excel by default contains 3 worksheets while creating a new Workbook. For creating a new workbook you can specify the number of Worksheet that a Workbook needs to contain. This can be modified using Excel Options. Listed below are steps for increasing number of Worksheets for a new Workbook in Excel 2013, Excel 2010 and Excel 2007

In Excel 2013 and Excel 2010 –> Click on File menu and then Options.

increase sheets in Workbook in Excel 2013

In Excel 2007 –> Click on Excel Options and then Popular menu.

Excel Options in Excel 2007

Increase worksheets for new workbook in Excel 2007

Under When creating new workbooks section there is include this many sheets fields. This can be used for increasing the number worksheets while creating a new workbook. The minimum value is 1 and the maximum is 255. Check out the below video demo to increase worksheets size in Excel 2013

Also See: How to move or copy worksheets in Excel 2013

Repeat action keyboard shortcut in Microsoft Office

By Leave a Comment

Microsoft Office Applications such as Word and Excel, last action can be repeated using keyboard shortcuts. For example if you have formatted a word with specific style and you want to repeat/apply the same format for other words then you can press F4 or Ctrl + Y or Alt + Enter. This can be used for copying drawings or formatting excel cells thus reducing the steps and saves time.

Change the keyboard shortcut for Repeat Action

Microsoft Office users can change the keyboard shortcut associated for Repeat action using Settings. Let us see these steps in Word 2016 & 2013

Step 1: Click File menu then Options and navigate to Customize Ribbon

Customize Keyboard Shortcuts in Microsoft Office

Step 2: In the Customize Ribbon screen, click Customize button available next to Keyboard shortcuts.

Change keyboard shortcut for Repeat Action

Step 3: In the Customize Keyboard window, select All Commands under Categories and pick EditRedoOrRepeat under Commands. You should be able to see the keys that are currently associated with Repeat action.

Step 4: Navigate to Press new shortcut key option and enter the keyboard shortcut.

Step 5: Click Assign to confirm and apply your changes.

How to quickly block sender in Outlook

By Leave a Comment

If you are receiving junk or spam emails in your Outlook email client and you do want to receive emails from these senders then you can use Junk email settings in Outlook to block these senders. To quickly block a sender in Outlook 2016, 2013 & 2010, select by right clicking the email and pick Block Sender option from the menu list.

image

This would display the following confirmation message and the message will be moved to the Junk email folder.

image

Instead of selecting Junk email options from the context menu, you can also try the Junk menu option which is available as part of the Home Menu.

image

Print list of emails in Outlook

By 1 Comment

We know how to quickly print an email message in Outlook 2016, 2013 & 2010. And in this tutorial we will be seeing the steps required for printing the list of emails in Inbox or any folder. This would be quite useful when you have daily task schedule meeting with your team and the tasks for each individual is allocated based on the emails received for that day.

Click the File menu and select Print from the menu list.

image

Then navigate to Settings section and select Table Style from the list. This would only print heading information of the emails as displayed on your Inbox.

image

In case if you want to include other columns in the list then you can use the View –> Change View Settings to pick the desired columns.

Different ways to find bookmarks in Word

By Leave a Comment

We had earlier seen about the steps required to insert bookmark in Word 2016, 2013 & 2010. This article explains the different ways to find out and navigate to bookmarks in a Word document.

Bookmark Option

Users can quickly launch the Bookmark option by pressing Ctrl + Shift + F5. Bookmark option allows users to create new bookmark as well as navigate to existing bookmark. In the Bookmark option window, you can navigate to a bookmark by either by double clicking on the name or by selecting the name then clicking the Go To button.

image

Find and Replace Dialog

Users can also navigate to bookmark using the Find and Replace dialog. Press F5 to launch Find and Replace dialog, then click GoTo tab and enter bookmark name and press Enter.

image

 

And if you have created many bookmarks and don’t remember the name of the bookmark then you can you pick it from the bookmark list. In the Go to what option, select Bookmark from the option list. A drop down list would be appear below the Enter bookmark name with list of available bookmarks. Pick the bookmark name from the list and click the Go To option.

image

Show or hide scroll bars in Word

By 5 Comments

In this tutorial we are going to see how to show or hide scrollbars in Word 2016, 2013 & 2010. Microsoft Word users can use the settings available as Word Options to show or hide vertical and horizontal bars.

image

Display Settings – Horizontal and Vertical Scroll bars

Click the File menu –> Options, this would display the Word Options window.

image

In the Word Options window, click Advanced tab and scroll down to Display section. Now you can show or hide scroll bars using the check boxes with label as “Show horizontal scroll bar” and “Show vertical scroll bar”. After making changes to the required check boxes, click OK button to confirm and save the changes.

Quickly print emails and attachments in Outlook

By Leave a Comment

Outlook 2016, 2013 and Outlook 2010 allow users to quickly print email & attachments using quick print options available as part of context menu. This is quite useful when you do not want to open an email and print the attachments.

Enable default printer

First you need to enable the default printer under Print options. Click File menu –> Print

Print Options in Outlook 2013 and Outlook 2010

In the Print screen, click Print Options button and mark the check box with caption as “Print attached files. Attachments will print to the default printer only.”

Set default printer in Outlook 2010 and Outlook 2013

Quick Print in Outlook 2013 and Outlook 2010

Now you can navigate to the email with attachment. Right click and select Quick Print from the right click context menu.

Quick Print attachment in Outlook 2013 and Outlook 2010

How to add background color to paragraph in Word

By 2 Comments

In this short tutorial we are going to see how to add background color to texts or paragraph in Word 2016, Word 2013 and Word 2010. For example, if you want to add background color to a paragraph then you can follow the below mentioned steps.

  • Select the paragraph and navigate to Paragraph section under Home menu.

image

  • Click the arrow pointing downwards with paint icon.

image

  • Now pick the desired color under Theme Colors or Standard Colors. You could immediately see the preview of the color shading effect for the selected Paragraph.
  • If you want to add background shading with custom color then click More Colors option and define your colors under Custom tab.

image