• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

Office 2010

Prevent users from adding new worksheet in Excel

January 25, 2016 by Admin 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.

image

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.

image

Filed Under: Excel, Excel 2010, Excel 2013, Excel 2016, MS Office Tagged With: add sheet, Excel 2010, Office 2010, prevent, Protect Workbook Structure, Worksheet

Repeat action keyboard shortcut in Microsoft Office

November 18, 2015 by Admin 2 Comments

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.

Filed Under: Excel, MS Office, Office 2007, Office 2010, Office 2013, Office 2016 Tagged With: Microsoft Office, Office 2007, Office 2010, Office 2013

How to hide row and column headers in Excel

October 19, 2015 by Admin 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.

row and column headers in Excel 2013 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.

Show row and column headers in Excel 2013 and Excel 2010

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

 

Excel worksheet without row and column header

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

Filed Under: Excel, Excel 2010, Excel 2013, Excel 2016, MS Office Tagged With: Excel 2010, headers, hide, Office 2010

How to check version of Excel

October 17, 2015 by Admin 3 Comments

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.

Help menu in Excel 2013 and Excel 2010

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

About Microsoft Excel window in Excel 2013 and Excel 2010

Screenshot in Excel 2013

About Excel option 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

Excel version in Excel 2013 and Excel 2010

Also See: Disable automatic conversion of hyperlink in Excel

Filed Under: Excel, Excel 2010, Excel 2013, Excel 2016, MS Office Tagged With: About Excel, Check Version, Excel 2010, Office 2010

How to quickly block sender in Outlook

October 13, 2015 by Admin 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.

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

Filed Under: Office 2010, Outlook 2010 Tagged With: block sender, Junk email, Office 2010, Outlook 2010

How to Insert, Delete, Customize Comments in Excel

July 22, 2015 by Admin 8 Comments

This tutorial provides information on the comment feature available in Excel 2013 & Excel 2010. The following will be covered as part of this tutorial.

  • How to insert comment
  • Customize the comment box
  • Navigate between Comments
  • Delete Comment

How to insert comment

Excel allows users to insert comment using the options available as part of the Review menu. But if you want to quickly insert then right click on the cell and select Insert Comment from the listed menus.

image

image

 

Customize Comment

A typical comment box in Excel is as shown below.

image

In order to change the name that appears on the Comment box, click on the File menu then the Option link then in the General tab, navigate to Personalize your copy if Microsoft Office and enter your desired name in the User name box. Click OK button to save the changes. Now the entered name will appear when you Insert new Comments.

image

Similarly if you want to change the Font Style used in Comment box then select then right click on the Comment box and select Format Comment menu option.

image

The Format Comment window allows you change the Comments Font Style.

image

Navigate between Comments

If you have more than one comment inserted in the Excel worksheet and you want to navigate between the comments then you can use the menu options available as part of the Comment section under Review menu. The list option includes Show All Comments, Previous and Next.

image

Delete Comment

A Comment can be quickly deleted are hidden by right clicking on the cell and selecting the required menu option. You can also use the menu option available as part of the Comments section under Review menu.

image

image

By this way you can Insert, customise, navigate and delete comments in Excel 2013 and Excel 2010

Filed Under: Excel, Excel 2010, Office 2010 Tagged With: comments, Cutomize, Delete, Excel 2010, hide, Insert, navigate, Office 2010, Show

  • Go to page 1
  • Go to page 2
  • Go to Next Page »

Primary Sidebar

Recent Posts

  • A Guide to Using the MAX and MIN Functions in Excel
  • How to display fractions in Excel
  • How to Separate a Person’s First and Last Name in Excel
  • How to Verify Email Addresses in Google Sheets: A Step-by-Step Guide
  • How to increase number of worksheets Excel

blogmines.com Copyright © 2023