Microsoft Excel is a workhorse and infrequently shops precious and delicate information, so it’s no shock that “tips on how to password shield an Excel spreadsheet” is such a typical search. There are an unimaginable quantity of options in Excel that will let you do absolutely anything you’d count on to do with information. Fortuitously, amongst these options is straightforward methodology that permits you to customise ranges of safety for a spreadsheet.
If you happen to don’t need to disguise the whole sheet, these safety choices additionally will let you shield particular person cells, rows, or columns — or the formulation contained inside them. This performance implies that customers can view a cell’s worth however not the method used to get to that worth. On this article, we are going to set our focus to locking particular sheets solely.
Observe alongside and also you’ll know tips on how to lock a complete spreadsheet and shield it with a password in seconds.
Find out how to Lock Particular Sheets in Excel
1. To lock an Excel spreadsheet, open your Excel file and navigate to the spreadsheet by clicking its identify in your Sheet Tabs.
2. Upon getting opened the sheet you need to shield, click on Evaluate Tab in your Navigation Ribbon. The Evaluate Tab offers instruments to test and shield your Excel file.
3. Below the Defend part of the Evaluate Tab, click on the Defend Sheet button. A small window ought to seem after following this step.
4. Within the Defend Sheet window, enter your most popular password to your Excel sheet and click on OK. Then, choose the actions your sheet’s viewers can do for this sheet below the Enable all customers of this worksheet to: part.
5. Lastly, reenter your password within the affirmation window and click on OK. Your spreadsheet ought to now be protected towards unauthorized use.