39. Protecting a worksheet with a password
Protecting a Worksheet with a Password
Protecting a worksheet in Excel helps prevent unauthorized edits. Let’s learn how to set and verify a password:
Steps to Protect a Worksheet
- Step 1: Go to the Review tab and select Protect Sheet.
- Step 2: Enter a password and confirm it.
- Step 3: To edit the sheet, you must enter the password to unprotect it.
Interactive Example
Worksheet Content (Editable)
Set a password to protect the worksheet. To edit again, enter the correct password to unprotect it.
Comments
Post a Comment