Password Protect Excel Sheet From Viewing 2016. If you do not want to share the excel file with anyone and have personal information which you do not want other to see, then the most common method is to protect an excel file by encrypting it with a password. Uncheck the actions you deny the users to perform, and click ok.
Encryption is something that we should always do with sensitive data. In excel, head to file > info. If your excel file contains more than one protected sheet, run the macro for each sheet individually to unprotect it.
After making sure excel 2016 worksheet is finished editing, turn to file info protect workbook, where you can choose an option encrypt with password to set open password to this excel workbook, protecting all of worksheets in it.
In this tutorial we’ll show you 2 ways to hide / unhide worksheet in excel 2016 / 2013 / 2010 / 2007. Hide one worksheet that you want to protect. In the resulting dialog, enter a password, as shown in figure d, and click ok. A worksheet in excel is like a page of the workbook shown by a tab at the bottom of the spreadsheet document.