With the Excel file open select File in the top-left corner of the screen, followed by Info. Select Protect Workbook, then choose Encrypt with Password.

There are several options available to you to protect your Excel file with a password. Remember that once you protect the Excel file, you cannot open it without entering the password.

Add a password and expiry date to an Excel sheet link If you use Microsoft's OneDrive cloud platform to save and share Excel files, you can password-protect and set an expiry date for a shared link.

At the file level, you can password protect an Excel workbook in two ways: You can determine who can get in and who can save changes.

Do not worry if you have lost your Excel password there are ways that you can still access spreadsheets. Check out our guide on how to unlock Excel spreadsheets without a password to learn more.

It is possible to create a macro in an Excel sheet that unlock the sheet which is already protected by a password. Users can easily prepare a document in the sheet and then lock it again with a ...

Key Takeaways : Excel spreadsheets can be protected by Edit Ranges, Sheet Protection, Workbook Protection, File Modify Password, VBA Project Password, and File Open Password.

Anyone can open and view the data, but only those who know the password can modify the contents–you protect the formulas and everything else. But remember, viewers can see the formulas.

Launch Excel and open the protected worksheet. Select the "Review" tab, and then click "Unprotect Sheet." Enter the password, if prompted.

You can make Excel always open old spreadsheets in Protected View. Enable or disable Protected View using in-built setting, Group Policy, Registry.