Yes. In Excel for Microsoft 365 on Windows, use File > Save As > Browse, open Tools > General Options in the Save As dialog, and enter a Password to modify; you can also select Read-only recommended. People without the password can open the workbook as read-only, but this does not stop them from viewing or copying its contents.
What Read-Only Means in Excel
Read-only describes how a workbook is opened, not a guarantee that nobody can change or redistribute its information. Excel offers several controls that sound similar but serve different purposes. Choosing the right one depends on whether you want to discourage accidental edits, restrict changes to particular cells, or prevent unauthorized people from opening the file at all.
- Password to modify: Allows someone to open and read the workbook without the password, while requiring the password to open it with editing enabled. The reader can usually choose a read-only option instead.
- Read-only recommended: Displays a recommendation when the file opens. It is a prompt, not a lock; a person can choose to edit the file anyway.
- Protect Sheet: Restricts changes to cells and certain worksheet actions. It does not hide the sheet’s contents or encrypt the workbook.
- Password to open: Encrypts the workbook so a password is needed to open and read it. This is the relevant option when the contents themselves should not be accessible to everyone.
For example, if you send a price list to colleagues who should consult it but not casually alter it, a password to modify or read-only recommendation may be suitable. If the file contains confidential information, a read-only prompt is not enough: use file encryption and share the password securely.
Set a Password to Modify on Windows
Use the desktop version of Excel for Microsoft 365 on Windows. Menu labels can vary slightly between builds, but the setting is in the Save As dialog rather than on the worksheet ribbon.
- Open the workbook and choose File > Save As > Browse. Choose a location and file name if you are saving a new copy.
- In the Save As dialog, select Tools near the Save button, then choose General Options. If Tools is not visible, check the dialog’s dropdown or options menu.
- Enter a password in Password to modify. Select Read-only recommended as well if you want Excel to display a read-only prompt even for people who do not have the password.
- Select OK, enter the password again when prompted, and save the workbook.
- Close the file and reopen it to confirm the prompt behaves as expected. Keep the password somewhere secure and provide it separately from the workbook when appropriate.
When another person opens the file, Excel asks for the password to modify. Someone who does not know it can choose the read-only option and view the workbook. Depending on the version and prompt, the person may also be able to save a separate copy. The original file’s password setting does not prevent a recipient from taking screenshots, copying visible data, or manually creating another workbook.
To remove or change the setting, open the workbook with permission to modify it, return to File > Save As > Browse > Tools > General Options, clear the password or replace it, and save. A new copy may be preferable if you need to preserve the original protected version.
Protect a Worksheet from Editing
If your goal is to let people edit designated input cells but keep formulas and layout from being changed, use worksheet protection. In Windows Excel, select Review > Protect Sheet. Choose the actions that users may still perform, enter a password if desired, and confirm it. The permissions list can allow activities such as selecting cells, formatting cells, or using filters, depending on the settings you choose.
By default, cells are marked as locked, but that setting has no effect until you protect the worksheet. To leave specific cells editable, select them before protecting the sheet, press Ctrl+1 to open Format Cells, choose the Protection tab, and clear Locked. Then turn on Review > Protect Sheet. For example, in a mileage form you could unlock the date and distance entry cells while leaving totals and formulas locked.
Sheet protection is useful for preventing routine or accidental changes, not for keeping data secret. Microsoft describes worksheet protection as a way to control editing, not as a security feature. A person who can read the workbook can still see its data, and the protection is not a substitute for encrypting a sensitive file. Protecting the workbook structure through Review > Protect Workbook is another separate control: it can restrict actions such as adding, deleting, or moving sheets, but it does not make the worksheet contents private.
Choose the Right Protection
Match the setting to the job the recipient needs to do. It is often helpful to combine controls, but using more passwords than necessary can make a workbook difficult to maintain.
- Readers should view but not edit the shared copy: Use Password to modify, or Read-only recommended if a reminder is enough. Remember that these settings do not prevent copying or saving a separate version.
- Users should fill in a form: Unlock the intended input cells, then protect the worksheet. Consider protecting formulas and the workbook structure too, while testing that users can still do their work.
- Only approved people should see the contents: Use Password to open, available through File > Info > Protect Workbook > Encrypt with Password on Windows. Share the password through a separate, appropriate channel.
- You need to control who can edit a shared company file: Store it in a location with access permissions, such as an organization’s supported SharePoint or OneDrive environment, and grant people the appropriate view or edit access. A local read-only prompt is not a substitute for managed access controls.
These approaches can be combined. A workbook can require a password to open and also protect individual sheets after it opens. In that case, the first control governs access to the file, while the second limits editing within it. Be careful not to make the workflow so restrictive that authorized users cannot enter data or update the workbook.
Password to Open Versus Password to Modify
The difference is important. A password to open is intended to keep people without the password from reading the workbook. A password to modify lets people without the password open it read-only. If you put confidential salary details in a workbook and use only Password to modify, anyone who receives the file can still read those details; they are merely discouraged or prevented from editing the protected copy.
On Windows, the encryption setting is under File > Info > Protect Workbook > Encrypt with Password. Enter and confirm a password. To remove it later, use the same command and clear the password field before saving. Passwords are case-sensitive. If a password to open is lost, Microsoft cannot recover the workbook password for you, so keep a secure backup or record according to your organization’s policy. Do not rely on a password you cannot retrieve.
A password to modify should also be treated as a practical editing restriction, not as a guarantee that a recipient cannot make another copy or reproduce visible content. If the requirement is that a particular person must never access the information, do not send them a readable copy in the first place; use access permissions to control who can obtain the file.
Excel on Mac and Excel for the Web
In Excel for Mac, password options are available from File > Passwords in supported desktop versions. The dialog provides options such as Password to open, Password to modify, and Read-only recommended. The exact labels and placement can vary by release, so check the current dialog before saving and reopening a test copy to verify the result.
Excel for the web does not provide the same desktop Save As General Options workflow for setting a password to modify. Its available protection and sharing features can depend on the file and account. If you need the specific password-to-modify prompt, set it in the desktop application. For a file stored online, use the sharing controls of the storage service to decide who can view or edit it; do not assume a read-only prompt alone enforces an access policy.
On Mac, common keyboard shortcuts differ: Command+1 opens Format Cells where Windows uses Ctrl+1. The worksheet protection command is still on the Review tab in the desktop ribbon, although ribbon layout can differ between platforms and versions.
Common Problems and Safer Practices
If Excel does not show the expected prompt, first confirm that you saved the copy with the setting and then close and reopen that exact file. A common source of confusion is changing a workbook but reopening an older copy from a different folder. You can also test with a duplicate so you do not accidentally disrupt the version people currently use.
- Read-only recommended does not force read-only access. It asks the user to consider opening the file read-only. Anyone may choose to proceed with editing.
- Sheet protection does not hide formulas or data. It controls permitted worksheet actions, not who can view the workbook.
- Do not email the password beside the file. If a password is needed, share it through a separate channel suitable for the sensitivity of the information.
- Keep a controlled backup. Before changing encryption or protection settings, preserve a copy in a secure location. Test the saved file and confirm that authorized users can open it.
- Use strong, unique passwords for sensitive files. A short or reused password is easier to guess or may expose other accounts if it is disclosed.
Also consider whether recipients need the full workbook. If they only need a report, sharing a PDF or a carefully prepared export may reduce the chance of unintended edits to formulas or source data. A PDF is not a security boundary either, but it can be a more appropriate viewing format when spreadsheet interaction is unnecessary.
Frequently Asked Questions
Can I make an Excel sheet read-only without a password?
Yes. Choose Read-only recommended in the General Options dialog to show a prompt, or set file permissions in a supported storage service. The recommendation is voluntary, so it cannot guarantee that a recipient will not edit a copy.
Can someone edit a sheet if they do not know the password?
With a password to modify, they can generally open the workbook read-only, but cannot use that password-protected copy with editing enabled. They may still copy visible content or save a separate version. Worksheet protection is a different control and should not be treated as strong security.
Does Protect Sheet encrypt the workbook?
No. Protect Sheet limits selected editing actions on a worksheet; it does not encrypt the file or stop someone from viewing its contents. Use Encrypt with Password when access to the contents themselves should require a password.
How do I remove read-only protection in Excel?
If the file uses a password to modify, open it with that password, return to Save As > Tools > General Options, remove the password or read-only recommendation, and save. If you do not have the required password, ask the file owner or administrator for an authorized copy.
Can I password-protect only one worksheet?
Yes. Select Review > Protect Sheet and set the permissions for that worksheet. This protects editing on that sheet, but it does not prevent readers from opening the workbook or seeing its contents.
Related
- How to Compare Two Excel Sheets and Find Every Change
- How to Compare Two Excel Sheets
- Excel Not Responding: How to Unfreeze It Safely
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Cell Character Limit: What 32,767 Really MeansAn Excel cell can contain up to 32,767 characters. That is the maximum stored in one cell in…
- Attendance Log Excel Template: Build One That WorksAn attendance log Excel template is a worksheet for recording who attended, when they arrived or left, and…
- Apply a Dropdown to an Entire Column in Google SheetsTo apply a dropdown to a whole column in Google Sheets, select the column or enter its range…
- Conditional Dropdowns in Google Sheets: How They WorkTo make a conditional (dependent) dropdown in Google Sheets, create a named range for each group of choices,…
- Excel Mode With Text: Find the Most Frequent Text ValueExcel’s MODE.SNGL and MODE.MULT functions work with numbers, not words. To find the most frequent text value, count…
- Camping Meal Planner Spreadsheet: Plan Meals and Pack FoodA camping meal planner spreadsheet helps you map meals to each day, estimate how much food to bring,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.