Wednesday, March 13, 2013

How to Hide Password Protect a Sheet Within Excel


1. Open the Excel worksheet you want to password protect and hide.
2. Place your cursor on the worksheet tab at the bottom of your spreadsheet.
3. Right click over the tab and choose 'Protect Sheet' from the pop-up menu. The “Protect Sheet” dialog box will open.
4. Add a check mark to 'Protect worksheet and contents of locked cells.' Insert the password you want to use into the 'Password to unprotect sheet' text box.
5. Choose the options you want to allow and press 'OK.' Re-enter your password in the “Confirm Password” dialog box and press “OK.”
6. Right click on the worksheet tab again and select 'Hide' from the options. The worksheet will be hidden from view.

Blogger news