The fastest way to make an Excel file read-only
You can make an Excel file read-only in three ways, depending on whether you want to protect it every time someone opens it, or just this once. The quickest method is to use Windows File Properties: right-click the Excel file, select Properties, check the Read-only box under Attributes, and click Apply. This prevents anyone from saving changes to the file without first unchecking that box.
If you want more control — like letting people view the file but warning them it's read-only, or protecting only certain parts of the spreadsheet — Excel's built-in protection features give you more options. The method you choose depends on whether you're sharing the file with others or just want to prevent yourself from accidentally editing it.
Key Takeaways
- The Windows File Properties method (right-click, Properties, check Read-only) is the simplest way to lock a file so changes cannot be saved without unchecking the box first.
- Excel's "Save As" dialog lets you open a file in read-only mode every time, which warns users but still lets them save a copy if they want.
- Sheet protection in Excel lets you lock specific cells or sheets while leaving others editable, useful when you want people to fill in certain fields but not change formulas.
- Workbook protection adds a password requirement to make changes, giving you control over who can edit the file.
Using Windows File Properties to lock the file
This method works on any Windows computer and requires no Excel knowledge. Right-click the Excel file you want to protect, then click Properties at the bottom of the menu. In the Properties window, look for the Attributes section near the bottom. You will see a checkbox next to Read-only — check it, then click Apply and OK.
Once you do this, anyone who tries to open the file and make changes will see a message saying the file is read-only. If they try to save, Excel will ask them to save a copy with a different name instead of overwriting the original. This is the most reliable way to prevent accidental changes, because the file itself is locked at the operating system level, not just within Excel.
To unlock the file later, repeat the same steps and uncheck the Read-only box. You need to be the file owner or have administrator rights on the computer to change this setting.
Opening a file in read-only mode within Excel
If you want to open an Excel file in read-only mode just this once, or want to give others the option to open it that way, use the Open dialog inside Excel. Click File, then Open, and navigate to your file. Instead of double-clicking it, right-click the file and select Open Read-Only. The file will open with a notification bar at the top saying it is in read-only mode.
This method does not change the file itself — it only affects how you open it this time. The next time you or someone else opens the file normally, it will be editable again. This is useful when you want to review a file without risking changes, or when you want to send a file to someone and suggest they open it this way.
Protecting specific sheets or cells in Excel
If you want people to view and edit certain parts of your spreadsheet but not others, use Excel's sheet protection feature. Click the Review tab at the top, then click Protect Sheet. A dialog will appear asking which elements you want to allow people to change — by default, it lets them edit cells but not change formatting or delete rows. You can add a password if you want, though it is optional.
Before you protect the sheet, unlock the cells you want people to be able to edit. Select those cells, right-click, choose Format Cells, go to the Protection tab, and uncheck Locked. Then protect the sheet. Now only the unlocked cells can be edited; everything else is locked.
This approach is useful for templates where you want people to fill in certain fields but not change your formulas or headers. You can protect multiple sheets in the same workbook, and each sheet can have different permissions and different passwords.
Protecting the entire workbook with a password
To prevent anyone from adding, deleting, or rearranging sheets in your workbook, use workbook protection. Click File, then Info, then Protect Workbook, and select Encrypt with Password. Type a password and click OK, then type it again to confirm. Now the file cannot be opened without that password.
This is different from sheet protection — it locks the structure of the workbook itself, not the contents of individual cells. Use this when you want to prevent someone from reorganizing your sheets or adding new ones. If you forget the password, there is no built-in way to recover it, so write it down somewhere safe.
Choosing the right method for your situation
Use Windows File Properties if you want the simplest, most foolproof protection. Anyone who tries to save changes will be forced to save a copy instead. This works even if they do not know Excel well.
Use Open Read-Only if you are sharing a file temporarily and want to warn people not to edit it, but you do not need to prevent them from doing so. They can still choose to save changes if they want.
Use Sheet Protection if you have a template or form where certain people should be able to fill in specific cells but not change the rest of the spreadsheet. This gives you fine-grained control over what each person can edit.
Use Workbook Protection if you want to prevent people from adding or removing sheets, or if you want to require a password to make structural changes to the file.
What happens when someone tries to edit a read-only file
If a file is locked using Windows File Properties, Excel will open it normally but display a notification bar saying the file is read-only. If the person tries to save their changes, Excel will show a dialog asking them to save a copy with a new filename instead. The original file remains unchanged.
If a sheet is protected, the person can still open and view the file, but when they try to click on a locked cell and make changes, Excel will show a message saying the sheet is protected. They can edit any unlocked cells without restriction.
If the workbook is password-protected, the file cannot be opened at all without entering the correct password. Excel will prompt for the password before the file opens.
Frequently Asked Questions
Can someone remove the read-only protection if I use Windows File Properties?
Yes, if they have access to the file's Properties dialog and are not restricted by administrator settings. The read-only attribute is a basic protection, not encryption. If you need stronger protection, use Excel's password-based sheet or workbook protection instead.
What if I forget the password I set for sheet protection?
Excel does not have a built-in password recovery tool. If you forget a sheet protection password, you will need to use a third-party tool designed to remove Excel protection, though results vary. For important files, store your passwords in a password manager or write them down in a secure location.
Can I make a file read-only on a Mac?
Yes. In Finder, right-click the file, select Get Info, and check the Locked box. In Excel on Mac, you can also use File > Info > Protect Workbook to add password protection. The steps are slightly different but the result is the same.
If I protect a sheet, can people still print it?
Yes, by default. When you protect a sheet, you can choose whether to allow printing in the protection dialog. If you want to prevent printing, uncheck the Print option before you apply the protection.
Does read-only protection work if someone copies the file to a different folder?
The Windows File Properties read-only attribute stays with the file, so yes. However, if someone has write access to the folder where the file is stored, they can change the attribute back. For stronger protection, use Excel's password-based methods instead.