protect sheet with password in Excel
Q72. In Excel, how can I prevent edits on my worksheet by protecting it with a "Password"?
For example, I have a data table in my worksheet sourced from elsewhere. Data in the Table cannot be altered at any cost as it affects the rest of my Workbook. In Excel, how can I prevent users from editing this sheet, even inadvertently?
To do it in Excel, here is the answer:
a) Click on "Protect Sheet" under "Review".
b) In the "Protect Sheet" dialog box that pops up, enter a "Password". Click OK.
c) In the "Confirm Password" dialog box that pops up, re-enter "Password". Click OK.
d) The Worksheet is now password protected. When the user tries to edit a cell, following message pops up.