Protecting an Excel file is fairly straightforward, but before processing you need to decide whether you will be protecting a single worksheet, or an entire workbook. After choosing your course of action, find your version below and proceed.
- Warning:-- Protecting a single worksheet only covers that specific worksheet. Any other spreadsheets in the Excel file (workbook) will be left open and unprotected.
For Excel 2003 and earlier versions, to protect a worksheet or workbook, go to Tools > Protection and select either Protect Sheet or Protect Workbook. Please find below Image for reference.
in this window select several additional options, depending on whether you are protecting a worksheet or workbook. in this window, you can also enter a password to protect the worksheet or workbook further. If you enter a password, you will be prompted to enter the password again for confirmation.
Excel 2007
In Excel 2007 and later, the process is essentially the same, just with different tab names. To protect a worksheet or workbook, go to the Review tab and select either Protect Sheet or Protect Workbook. Please find below Image for reference.
- Tip:- To remove the protection from a workbook or worksheet, follow the same steps above. The options will now say "Unprotect" instead of "Protect."
0 comments:
Post a Comment