When you share files Excel with other users, you may want to protect a sheet from being changed.
Join the channel Telegram of the AnonyViet 👉 Link 👈 |
How to Protect Excel Sheets
1. Right click on the sheet.
2. Select Protect Sheet.
3. Enter the password.
4. Select the actions you allow users to perform on the worksheet.
5. Press OK
Note: if you don’t select any action, the user can only view the Excel file!
6. Confirm the password and click OK.
Your spreadsheet is protected now. To unprotect a sheet, right-click the sheet and click Unprotect Sheet.
In addition, you can also view many other excel articles here.