This feature will give people warning if they try to edit the spreadsheet.
Instead, we recommend just turning on the protection without adding a password. However, be careful with password protection, as you can risk locking yourself out of the spreadsheet if you forget the password (unlike your Facebook account, for example, you can’t just reset your Excel spreadsheet password). Another nice feature is the ability to add a password. Only people who know the password can turn off the protection and make edits. In the same window, you also have the option of turning on certain functionality while keeping others locked. To turn on Protection, go to Tools > Protection. The Protection function locks all cells by default, so nobody can enter or alter any information. If you share spreadsheets with colleagues but don’t want them to change the content, the Protection function in Excel can be helpful.
