How to Password Protect an Excel Workbook for Read-Only Access
Question details
The user wants to configure an Excel workbook so that it opens as read-only by default and requires a password to modify the contents.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Sharing an Excel file where viewers should only read the document by default, but authorized users can edit it with a password.
- Observed behavior
- The options to set a password-to-modify and recommend read-only are not located under the standard Protect Workbook menu, but are instead accessed through the Save As dialog.
Ensure you have the target Excel workbook open and consider saving a backup copy before applying password protection, as a forgotten password cannot be recovered.
Set Password to Modify via the Save As Dialog
Use the General Options in the Save As dialog to assign a modification password and enable the read-only recommended prompt for the workbook.
In Excel 2013 and later versions, workbook protection settings for restricting editing access to authorized users while allowing general viewing are managed during the save process rather than the Review tab.
Click on the 'File' tab in the top-left corner of Excel, select 'Save As', and choose the folder location where you want to save the protected file.
In the Save As dialog box, locate the 'Tools' dropdown menu (usually positioned next to the Save button) and click on it. Select 'General Options' from the list.
In the General Options window, leave the 'Password to open' field blank if you want everyone to view the file. Type a secure password into the 'Password to modify' field and check the box that says 'Read-only recommended'.
Click 'OK'. A prompt will appear asking you to re-enter the modification password to confirm it. Type the password again, click 'OK', and then click 'Save' to apply the protection to your workbook.
Easily Secure Your Spreadsheets with WPS Office
WPS Spreadsheet offers a highly compatible and intuitive interface for securing your files. You can easily set passwords for reading and editing without navigating through complex sub-menus.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the spreadsheet you want to password-protect.
- 2. Access Document Encryption: Navigate to the 'Menu' (or the 'File' tab), select 'Document Encryption', and click on 'Encryption'.
- 3. Set the editing password: In the Encryption dialog box, leave the 'Document Password' blank so anyone can view it, but enter a secure password in the 'Password to modify' field.
- 4. Save the changes: Click 'OK', confirm your password when prompted, and save your document to apply the settings.
Frequently Asked Questions
Can I remove the password to modify later?
Yes. Open the file using the modification password, go to File > Save As > Tools > General Options, delete the password from the 'Password to modify' field, uncheck 'Read-only recommended', and save the file.
What is the difference between Password to Open and Password to Modify?
A 'Password to open' entirely blocks users from viewing the file without the password. A 'Password to modify' allows users to view the file in read-only mode without a password, but requires the password to make and save changes to the original file.
What happens if I forget the password to modify?
If you forget the password to modify, you will only be able to open the file in read-only mode. You cannot retrieve or recover the forgotten password, though you can still copy the read-only content into a new workbook.
Can I protect specific cells instead of the whole workbook?
Yes. Instead of using the Save As dialog, you can go to the Review tab, select 'Protect Sheet', and specify a password to prevent changes to locked cells within that specific worksheet.
