If you don’t want to hide the entire sheet, these security options also allow you to protect individual cells, rows, or columns — or the formulas contained within them. This functionality means that users can view a cell’s value but not the formula used to get to that value. In this article, we will set our focus to locking specific sheets only.  Follow along and you’ll know how to lock an entire spreadsheet and protect it with a password in seconds.

How to Lock Specific Sheets in Excel

  1. To lock an Excel spreadsheet, open your Excel file and navigate to the spreadsheet by clicking its name on your Sheet Tabs.
  2. Once you have opened the sheet you want to protect, click Review Tab on your Navigation Ribbon. The Review Tab provides tools to check and protect your Excel file.
  3. Under the Protect section of the Review Tab, click the Protect Sheet button. A small window should appear after following this step.
  4. In the Protect Sheet window, enter your preferred password for your Excel sheet and click OK. Then, select the activities your sheet’s viewers can do for this sheet under the Allow all users of this worksheet to: section. 
  5. Finally, reenter your password in the confirmation window and click OK. Your spreadsheet should now be protected against unauthorized use.