In this lesson, you can learn how to protect Excel files.
Protecting files in Excel is very important. It may happen that the results of your work will be destroyed. To avoid this, you need to know how to protect files in Excel.
Each file in Excel, you can password protect. It is also possible to protect the sheet so that nobody can change it. Lets learn how to do it.
File Password Protection
First, let's learn how to secure the opening of the file. This will be possible only after entering the password, which you will establish. Go to the Ribbon. Click Review, then click Protect and Share Workbook.
A window appears where you can enter a password. Preferably such that no one will be able to easily guess.
Alternatively, select File>Info>Protect workbook>Encrypt with password:
After entering the password, confirm it again.
Now to open the file you will need a password. A very important issue is to remember your password. Without it, we do not open the file.
Make as final (read only)
Similarly we can make the workbook read only using similar options:
Select File>Info>Protect workbook>Make as Final
Similarly we can make choose the Protect Workbook Structure option also.
The final way you can add protection at the workbook level is by protecting the workbook's structure.
This type of protection prevents people who don't have the password from making changes at the workbook level, which means they won't be able to add, remove, rename, or move worksheets.
Protecting a worksheet
Another possibility is to protect the sheet. It allows you to open the file it is true by others, but does not allow to make changes. In order to protect the sheet entering the Excel ribbon and further Review and select Protect Sheet.
In a next step, enter the password. Select also the extent to which a sheet is to be protected.
Since now anyone who wants to modify the worksheet, you will see this message:
Without the removal of protection in the Review tab and enter the password, edit the file will not be possible. I wish you all secure work in Excel!
Further reading: How To Send Email From Excel?