Office 2010

Prevent users from adding new worksheet in Excel

January 25, 2016 By Ravi Shankar 2 Comments

Excel 2016, 2013 and 2010 provides an option to prevent users from adding new worksheet to existing Workbook structure. So if you are the owner of Excel file and you do not want to allow other users to add any new worksheet, rename or move worksheet then you can use Protect Workbook Structure option to change the permission. You can access Protect Workbook Structure from the Info menu.

Click the File menu and then navigate to Info menu and click the drop down arrow under Protect Workbook option. From the list of available option select Protect Workbook Structure. This would display the following Protect Structure and Windows. Mark the check box with label as Structure. If you want to password protect it then enter a password in the Password field. Click Ok button to save and confirm the changes.

Go To specific page number in Word

January 14, 2016 By Ravi Shankar 5 Comments

In Word 2013 and Word 2010 you can go to specific page in the Word document using the Find and Replace dialog.

To display the Find and Replace dialog, Navigate to Home menu and click on the drop down arrow under Find menu.

Another shortcut for launching Find and Replace is by pressing Ctrl + G.

Navigate Go To tab and select Page option for Go to what and specify the page number under the textbox available under Enter page number label.

Also See: Insert and Save watermark in Microsoft Word

Repeat action keyboard shortcut in Microsoft Office

November 18, 2015 By Ravi Shankar 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

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

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.

What is a status bar in Word document

October 27, 2015 By Ravi Shankar Leave a Comment

Microsoft Word 2016, 2013 and 2010 displays a status bar at the bottom of a Word document. Word status bar displays information such word count, page number, line number, zoom, zoom slider, Language and many more details.

These details displayed on the word status bar can be configured by using the Customize Status Bar context menu. The Customize Status Bar can be accessed by right clicking the status bar.

In order to turn on or turn off the display of a feature, You can check or un check on the left hand side of a feature.

Also See: Find out character count Microsoft Word document

How to add a new page in Word

October 24, 2015 By Ravi Shankar 2 Comments

This is a short tutorial on Adding or inserting a new page in Word 2016, 2013 and 2010. This can be done using the options available as part of the Insert menu Word. To add a new page in a Word 2010 document, point the cursor to the place where you want to insert a page.

Navigate to the Insert menu and click the Blank Page menu option available as part of the Pages section.

This would insert a new page at place where the cursor placed before.

How to hide row and column headers in Excel

October 19, 2015 By Ravi Shankar Leave a Comment

Excel Worksheet by default displays the rows and columns header. For some reason if you want to hide these headers then you can use Excel Advanced Options. Listed below the steps to hide or unhide row and column headers in Excel 2016, Excel 2010 and Excel 2010.

Step 1: Click the File menu and then options link.

Step 2: In The Excel Options windows, select Advanced tab and scroll down to Display options for this worksheet section.

Step 3: To hide the rows and columns headers in a Excel 2010 worksheet, un mark the checkbox labelled as Show row and column headers.

Click OK button available at the bottom of the screen to confirm the changes.

Also See: How to hide header/footer while typing in Excel

How to check version of Excel

October 17, 2015 By Ravi Shankar Leave a Comment

In Excel 2016, 2013 and 2010, the version of excel can be checked using the Help or Account menu.

Click the File menu and select Help menu.

Navigate to the About Microsoft Excel section displayed on the right hand side. This would display the Excel Version details, as shown below.

Screenshot in Excel 2013

And if you want to see additional information then you can click on the Additional Version and Copyright Information. This would display the following About Microsoft Excel Window

Also See: Disable automatic conversion of hyperlink in Excel

How to quickly block sender in Outlook

October 13, 2015 By Ravi Shankar 15 Comments

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.

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

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.