Making an Excel file read-only protects it from accidental changes
You can make an Excel file read-only in three ways: by setting file properties in Windows or Mac, by using Excel's built-in protection features, or by saving the file in a read-only format. The method you choose depends on whether you want to prevent accidental edits, stop intentional changes, or both. File properties are the fastest route if you just want to warn people not to save over the original. Excel's protection features give you more control — you can let people view and print but block editing, or require a password to unlock changes.
Each method has a different purpose. Windows file properties work at the operating system level and affect anyone who opens the file. Excel protection works only within the spreadsheet and can be removed if someone knows the password. Read-only file formats like PDF prevent editing entirely but lose Excel's functionality. Pick the one that matches what you're trying to prevent.
Key Takeaways
- Setting a file to read-only through Windows or Mac properties is the simplest method and works for any user, but people can still remove the read-only flag if they have permission to edit the file.
- Excel's Protect Sheet feature lets you lock specific cells or the entire sheet while keeping the file in .xlsx format, and requires a password to unlock.
- Saving as a PDF or XPS file makes the spreadsheet completely non-editable in Excel, though you lose the ability to edit formulas or data.
- Read-only protection prevents accidental saves but does not stop someone from making changes and saving to a new file with a different name.
Setting read-only through Windows file properties
Right-click the Excel file on your computer and select Properties from the menu. In the window that opens, look at the bottom of the General tab for a checkbox labeled Read-only. Check that box and click Apply, then OK. Windows will now mark the file as read-only at the system level.
When someone opens this file in Excel, they will see a notification bar at the top saying the file is in read-only mode. If they try to edit and then save, Excel will ask them to save as a new file instead of overwriting the original. This prevents accidental overwrites but does not stop someone from deliberately saving a modified copy under a different name. The read-only flag can also be removed by anyone with write permission to the folder, so this method works best for shared drives where you trust people not to remove it.
On a Mac, right-click the file and select Get Info. Near the bottom of the window, check the box next to Locked. Close the window. The file is now read-only on your Mac, and the same behavior applies — people can view and edit but must save as a new file.
Using Excel's Protect Sheet feature
Open the Excel file and go to the Review tab at the top of the ribbon. Click Protect Sheet. A dialog box will appear with options for what people can and cannot do. By default, most actions are blocked — users can select cells and view formulas but cannot edit, delete, or insert rows and columns. You can customize these permissions by checking or unchecking boxes for specific actions.
At the bottom of the dialog, you will see a field labeled Password to unprotect sheet. This is optional — you can leave it blank if you just want to prevent accidental edits, or enter a password if you want to stop intentional changes. If you set a password, anyone who wants to unlock the sheet will need to enter it. Write down the password somewhere safe; Excel cannot recover it if you forget it. Click OK and enter the password again to confirm.
The file remains a normal Excel file (.xlsx) and people can still open it, view it, and print it. They simply cannot make changes unless they unprotect the sheet and enter the password. This is useful when you want to share a template or a finished report and prevent people from accidentally breaking formulas or changing data.
Protecting the entire workbook instead of individual sheets
If you want to lock the whole workbook rather than just one sheet, go to the Review tab and click Protect Workbook. This prevents people from adding, deleting, or renaming sheets. You can also set a password here. The difference between sheet protection and workbook protection is that sheet protection stops editing of cell contents, while workbook protection stops structural changes like adding new sheets.
You can use both at the same time — protect individual sheets to prevent cell edits and protect the workbook to prevent sheet changes. Most of the time, sheet protection alone is enough. Workbook protection is useful when you have a multi-sheet workbook and you want the structure to stay exactly as you designed it.
Saving as a read-only file format
If you want to make absolutely certain no one can edit the file in Excel, save it as a PDF or XPS file instead. Go to File and click Save As. In the Save as type dropdown, select PDF or XPS Document. Choose where to save and click Save. The file will now open in a PDF reader or XPS viewer instead of Excel, and editing is not possible.
The downside is that you lose all Excel functionality — formulas become static values, and anyone who needs to work with the data will have to retype it into a new spreadsheet. Use this method only when you are sharing a final report or a document that does not need to be edited. If people might need to use the data later, use sheet protection instead.
Comparing the three methods
| Method | How it works | Can be removed | File stays editable |
|---|---|---|---|
| Windows/Mac file properties | Sets read-only flag at operating system level | Yes, by anyone with folder permission | Yes, but must save as new file |
| Excel Protect Sheet | Locks cells and formulas within Excel | Yes, with password if set | Yes, but only unprotected cells |
| Save as PDF or XPS | Converts to non-editable format | No | No |
Use file properties when you want a simple warning and you trust your team not to override it. Use sheet protection when you want to keep the file in Excel format but prevent accidental or intentional changes to specific cells. Use PDF or XPS only when the file is final and no one will need to edit it.
What happens when someone tries to edit a read-only file
If a file is set to read-only through Windows properties, Excel opens it in read-only mode and displays a notification bar at the top. The user can still view and print the file, but if they make changes and try to save, Excel will ask them to save as a new file with a different name. The original file remains unchanged.
If a sheet is protected with Protect Sheet, users can click on cells and see the data, but when they try to type in a cell, nothing happens. If they try to delete a row or insert a column, Excel shows an error message saying the sheet is protected. If a password was set, they will see an option to unprotect the sheet, but they will need the password to proceed.
If the file is a PDF or XPS, the user cannot edit it at all in Excel — they can only view it in a PDF reader or XPS viewer. If they need to work with the data, they will have to copy it manually into a new spreadsheet.
Frequently Asked Questions
Can someone remove the read-only flag if I set it through Windows properties?
Yes, if they have write permission to the folder where the file is stored. They can right-click the file, open Properties, uncheck the Read-only box, and click Apply. This is why file properties work best as a courtesy reminder rather than a security measure. If you need stronger protection, use Excel's Protect Sheet feature with a password.
What if I forget the password I set for sheet protection?
Excel cannot recover a forgotten protection password. You will need to use a third-party tool to remove the protection, or recreate the file from scratch. Always write down passwords in a secure location before you set them.
Can I protect some cells but leave others editable?
Yes. Before you protect the sheet, select the cells you want people to be able to edit, 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. Everyone else is locked.
Does read-only protection stop someone from copying the data?
No. Read-only protection prevents editing and saving over the original file, but it does not stop someone from selecting all the data, copying it, and pasting it into a new spreadsheet. If you need to prevent data copying, you will need to use a more advanced security method or restrict access to the file itself.
Should I use file properties or Excel protection?
Use file properties if you want a simple, quick way to prevent accidental overwrites and you trust your team. Use Excel protection if you want to keep the file in Excel format and allow viewing but prevent editing, or if you want to lock specific cells while leaving others editable.