Home > Document > Excel > Where is Protect Sheet Command in Microsoft Excel 2007, 2010 and 2013
 

Where is Protect Sheet Command in Microsoft Excel 2007, 2010 and 2013?

How to Bring Back Classic Menus and Toolbars to Office 2007, 2010, 2013 and 365?
Just download Classic Menu for Office 2007 or Classic Menu for Office 2010 and 2013 (365)
Kutools for Excel: 120 Powerful New Features for Excel.
Office Tab: Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.


Familiar way to protect sheet if you have Classic Menu for Office

Classic Menu for Office inserts old menus and toolbars of Microsoft Excel 2003 into Microsoft Excel 2007, 2010 and 2013 Ribbon, and makes Excel 2007, 2010 and 2013 look like Excel 2003. If you have it, you have two methods to protect sheets:

Method A: Protect Sheet command in Tools Menu if you have Classic Menu for Office
  • Click Menus tab;
  • Click Tools drop down menu;
  • Click the Protection item;
  • Then you will the Protect Sheet item staying in the sub-item list of Protection.

Figure 1: Protect Sheet in Microsoft Excel 2010's Tools Menu

Figure 1: Protect Sheet in Microsoft Excel 2010's Tools Menu

Please click to know more information and free download Classic Menu for Office suites and programs.

 

Method B: Protect Sheet command in old toolbars if you have Classic Menu for Office

Under Menus tab you can get familiar toolbarhave exactly the same old toolbars as in your Excel 2003. And yYou can get access the Protect Sheet command in the old Toolbars according to the following screenshot:

Figure 2: Protect Sheet in Microsoft Excel 2010's Toolbar

Figure 2: Protect Sheet in Microsoft Excel 2010's Toolbar

Please click to know more information and free download Classic Menu for Office suites and programs.

 

Method C: Protect Sheet button in Additional Toolbar if you have Classic Menu for Office

If you are using Microsoft Excel 2007 and have installed Classic Menu for Office on your computer, you will easily find out the Additional Toolbar at far right of Toolbars under Menus. This Additional Toolbar collects useful buttons which are not staying in old Toolbar. Of course you can get the Protect Sheet button in this Additional Toolbar. Please note that this Additional Toolbar is only available in Classic Menu for Office 2007.

Figure 3: Protect Sheet button in Additional Toolbars

Figure 3: Protect Sheet button in Additional Toolbars

Please click to know more information and free download Classic Menu for Office suites and programs.

 

Back to Top

Find out Protect Sheet command in Ribbon without Classic Menu for Office

There are also two methods to protect sheet to get command button in Ribbon:

Method A: Protect Sheet button in Review tab

Go to the Changes group under Review tab, you will find out the Protect Sheet button as soon as possible.

Figure 4: Protect Sheet button in Microsoft Excel 2010's Review Tab

Figure 4: Protect Sheet button in Microsoft Excel 2010's Review Tab

 

Method B: Protect Sheet command in Excel 2010/2013’s backstage view
  • Click the File tab in Microsoft Excel 2010/2013;
  • Click Info button at left bar;
  • Click the Protect Workbook button in the middle section;
  • Then you will view the third item is Protect Current Sheet in the drop down list.

Figure 5: Protect Sheet in Microsoft Excel 2010's backstage view

Figure 5: Protect Sheet in Microsoft Excel 2010's backstage view

Please note that this method is only valid in Microsoft Excel 2010/2013, and Microsoft Excel 2007 does not support this way.

Please click to know more information and free download Classic Menu for Office suites and programs.

 

Back to Top

More Tips for Microsoft Excel 2007, 2010 and 2013 (includes Office 365)

 

 

Classic Menu for Office

Brings the familiar classic menus and toolbars back to Microsoft Office 2007, 2010 and 2013. You can use Office 2007/2010/2013 immediately without any training. Supports all languages, and all new commands of 2007, 2010 and 2013 have been added into the classic interface.

 

Classic Menu for Office 2010 and 2013

It includes Classic Menu for Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, Visio and Project 2010 and 2013.

 
 

Classic Menu for Office 2007

It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007.

Classic Menu for Excel 2010

Screen Shot of Classic Menu for Excel

 

 

 

 
 

2001- Addintools. All rights reserved.  Privacy Policy  |  Contact Us
If you have any questions or suggestions about our products or web site, please feel free to submit them to us. Thank you very much.