The quickest way to make a file read-only

The simplest method is to save your Excel file with read-only protection turned on. Open the file you want to protect, then go to File > Save As. Choose where to save it, enter the filename, and before you click Save, look for a button labeled Tools (in Windows) or check the box next to Read-Only Recommended (in Mac). Select General Options from the Tools menu, then check the box next to Read-only recommended. When someone opens the file later, Excel will ask them whether they want to open it in read-only mode — but they can still choose to edit it if they want.

If you need stronger protection that people cannot override without a password, you can set a password in that same General Options dialog. Type a password in the field labeled Password to modify, then click OK. You'll be asked to type it again to confirm. Now when someone opens the file, they must enter that password to make any changes. Without the password, they can only view the file.

This method works on both Windows and Mac versions of Excel, though the exact menu locations differ slightly between them.

Key Takeaways

  • The Read-only recommended option in Save As prompts users to open the file without editing, but they can override it without a password.
  • Setting a Password to modify in General Options prevents anyone from editing the file unless they know the password.
  • You can also right-click the file in Windows File Explorer, select Properties, and check the Read-only box to lock the file at the operating system level.
  • Protecting specific cells or sheets within a file is different from making the whole file read-only and requires using the Sheet Protection or Workbook Protection features.
  • If you forget the password you set, there is no built-in way to recover it, so store it somewhere secure.

Using Windows File Properties to lock the file

You can also make an Excel file read-only without opening it in Excel at all. Right-click the file in Windows File Explorer, then select Properties at the bottom of the menu. In the Properties window, look for a checkbox labeled Read-only near the bottom left. Check that box, then click Apply and OK.

When someone tries to save changes to that file in Excel, they'll see a message saying the file is read-only and asking whether they want to save it with a different name instead. This method is useful if you want to prevent accidental changes, but it's not as secure as password protection because someone with file access can uncheck that box in Properties and edit the file anyway.

Protecting specific sheets or cells instead of the whole file

Sometimes you want people to view and work with most of an Excel file but prevent them from editing certain cells or entire sheets. This is different from making the whole file read-only. Go to Review > Protect Sheet (or Protect Workbook if you want to lock the structure of the entire workbook). A dialog will open where you can set a password and choose which actions people are allowed to do — for example, you might let them edit data in certain cells but not delete rows or change formulas.

Before you protect a sheet, you need to mark which cells should be editable. Select the cells you want people to be able to change, right-click, choose Format Cells, go to the Protection tab, and uncheck the Locked box. Then protect the sheet. Now only the unlocked cells can be edited; everything else is locked.

This approach is useful when you're sharing a template or a form where you want people to fill in certain fields but not alter the structure or formulas you've set up.

The difference between read-only and protected sheets

Read-only protection locks the entire file — people can open it and view it, but they cannot make any changes at all. Protected sheet or workbook protection is more flexible. It lets you decide exactly what people can and cannot do. You might allow editing in data entry cells while preventing changes to headers, formulas, or the sheet tabs themselves.

Read-only is best when you want to share a finished document that should not be changed. Sheet protection is better when you're sharing a working file — like a budget template or a data entry form — where people need to add or update information in specific places but you want to prevent accidental or intentional changes to the rest of the file.

What happens when someone tries to edit a read-only file

If a file is set to read-only recommended, Excel will show a message when the file opens asking whether the person wants to open it in read-only mode. They can click Edit Anyway to make changes, or OK to view only. This is a soft protection — it's a warning, not a barrier.

If you've set a password to modify the file, the message will be different. It will say the file is read-only and ask for a password to enable editing. Without the correct password, the person cannot make changes. If they click Read-Only, they can view the file but not edit it.

If the file is locked at the Windows level (via Properties), Excel will let someone open it and make changes, but when they try to save, Excel will ask whether they want to save it with a new name instead, because the original file cannot be overwritten.

Removing read-only protection later

If you set read-only recommended, you can turn it off the same way you turned it on: go to File > Save As, click Tools > General Options, and uncheck Read-only recommended. Save the file.

If you set a password to modify, you'll need to enter that password to remove the protection. Open the file, go to File > Save As, click Tools > General Options, clear the password field, and save. If you've forgotten the password, there is no recovery method — you cannot remove the protection without it.

For sheet protection, go to Review > Unprotect Sheet (or Unprotect Workbook

When to use each method

Use read-only recommended when you're sharing a document with people you trust and you mainly want to prevent accidental changes. It's quick to set up and doesn't require managing passwords.

Use password-protected read-only when you need stronger protection — for example, if you're sharing financial data or a template that should not be modified without authorization. The password creates a real barrier, not just a prompt.

Use sheet or workbook protection when people need to work with the file but only in certain ways. This is common for forms, budgets, or data entry templates where you want to control what can be changed.

Use Windows file properties read-only as a lightweight option when you want to prevent accidental overwrites but don't need password-level security. It's easy to toggle on and off and works at the operating system level.

Frequently Asked Questions

Can I make a file read-only if I don't have permission to edit it?

No. You need to be able to open and save the file to change its read-only status. If the file is already locked and you don't have the password, you cannot modify its protection settings.

What if I set a password and now I can't remember it?

Excel does not have a built-in password recovery tool. If you forget the password you set to modify a file, you cannot remove that protection. Store passwords in a password manager or a secure location so you don't lose them.

Does read-only protection prevent someone from copying the data?

No. Read-only protection prevents editing and saving changes to the original file, but someone can still select, copy, and paste the data into a new file. If you need to prevent data copying, you'll need additional security measures outside of Excel's built-in tools.

Can I make a file read-only on Google Sheets or OneDrive?

Yes, but the method is different. In OneDrive or SharePoint, you can change the sharing permissions so people have view-only access. In Google Sheets, you can set sharing permissions to "Viewer" so people can see the file but not edit it. These are cloud-based alternatives to Excel's local file protection.

If I protect a sheet with a password, can people still see the formulas?

Yes. Sheet protection prevents people from editing cells, but they can still see formulas in the formula bar when they click on a cell. If you want to hide formulas, you need to format those cells as hidden and then protect the sheet, which will prevent people from seeing the formulas in the formula bar.