Why you might want a read-only Excel file

Making an Excel document read-only prevents anyone who opens it from accidentally changing formulas, deleting rows, or overwriting data. The file stays viewable and usable — people can read it, print it, copy numbers from it — but they cannot save changes back to the original.

This is useful when you have a spreadsheet that took time to build correctly and you want to share it without worrying someone will alter it. It is also a way to protect yourself: if the file gets passed around and someone changes a number, you know the original version is still intact somewhere.

Excel offers several ways to do this, ranging from straightforward (a one-click file property) to more find (password protection). The method you choose depends on how much protection you need and who you are sharing the file with.

Key Takeaways

  • The simplest method is to mark the file as read-only through Windows or Mac file properties, which prevents accidental changes but can be undone by the person who opens it.
  • Excel's built-in "Protect Sheet" feature locks cells and formulas but still allows the file to be edited if someone removes the protection without a password.
  • Password-protecting a sheet or workbook adds a real barrier — someone cannot unprotect it without knowing the password you set.
  • The read-only flag and sheet protection serve different purposes: one stops accidental saves, the other stops intentional edits to specific cells.

Making a file read-only through file properties (Windows)

This is the fastest method and requires no changes inside Excel itself. Right-click the Excel file in File Explorer, select Properties, and look for a checkbox labeled Read-only near the bottom of the window. Check that box and click explore, then OK.

When someone opens this file in Excel, they will see a notification bar at the top saying the file is in read-only mode. They can still view and print it, but if they try to make a change and then save, Excel will ask them to save as a new file instead of overwriting the original.

The limitation: anyone can uncheck that read-only box in Properties and edit the file anyway. This method stops accidental changes, not intentional ones. It is best used when you are sharing with people you trust or when you straightforward want a safety net against mistakes.

Making a file read-only through file properties (Mac)

On a Mac, right-click the Excel file and select Get Info. Near the bottom of the window, find the Locked checkbox and check it. Close the window.

When the file is locked, Excel will open it in read-only mode. Anyone who tries to edit and save will get a prompt asking them to save as a new file. Like the Windows method, this is a gentle barrier — someone can unlock the file by going back to Get Info and unchecking the box.

Protecting a sheet with a password in Excel

If you want stronger protection, use Excel's built-in sheet protection. Open the file, go to the Review tab (or Tools on Mac), and click Protect Sheet. A dialog box will appear.

You can set a password here, though it is optional. If you add a password, write it down somewhere safe — Excel cannot recover a forgotten password. The dialog also shows checkboxes for what users are allowed to do: by default, they can select cells and view the sheet but cannot insert rows, delete columns, or edit locked cells. You can adjust these permissions to fit your needs.

Click OK and enter the password again to confirm. Now the sheet is protected. Anyone who tries to edit a locked cell will see a message saying the sheet is protected. To unprotect it later, go back to Review > Protect Sheet and enter your password.

Protecting the entire workbook with a password

Sheet protection locks individual sheets. If you want to prevent someone from adding new sheets, deleting sheets, or moving them around, protect the workbook instead. Go to Review > Protect Workbook (or Tools > Protect Workbook on Mac).

A small dialog will ask for a password. This password protects the structure of the workbook — the arrangement and names of sheets — not the content inside them. You can use this alongside sheet protection for layered security.

Combining methods for stronger protection

For a file you are sharing widely or with people outside your organization, consider using more than one method. For example, you might set the file to read-only in Properties and protect the sheets with a password. This way, someone has to clear two hurdles to make changes.

Another approach: protect the sheet with a password, but leave the file itself editable. This lets people save a copy with their own notes while keeping the original formulas and structure locked. Choose the combination that matches how you expect the file to be used.

What happens when someone tries to edit a protected file

If a file is marked read-only in Properties, Excel opens it normally but shows a notification bar saying "This file is read-only." The person can still view and print, but saving changes requires saving as a new file.

If a sheet is password-protected, clicking on a locked cell shows a message: "The sheet is protected and some objects cannot be modified." Trying to edit a locked cell does nothing. If the person tries to unprotect the sheet without the password, Excel will not let them.

If the workbook is protected, the person cannot right-click a sheet tab to insert, delete, or rename sheets. They will see a message saying the workbook is protected.

Frequently Asked Questions

Can someone remove read-only protection without a password?

Yes. File-level read-only (set through Properties) can be unchecked by anyone who has access to the file. It is a courtesy barrier, not a security measure. Password-protected sheets and workbooks are harder to remove without the password, though determined users may find workarounds.

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

By default, yes — they can click on a cell and see the formula in the formula bar. If you want to hide formulas, format those cells as hidden before protecting the sheet, then check the "Hide formulas" option in the protection dialog. The formulas will not display even if someone clicks on the cell.

What if I forget the password I set for sheet protection?

Excel cannot recover a forgotten password. You will need to use the original unprotected file or recreate the sheet. This is why it is important to store passwords somewhere safe if you use them.

Can I protect some cells but leave others editable?

Yes. Before protecting the sheet, select the cells you want people 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.

Does read-only protection work the same way in Google Sheets?

No. Google Sheets uses a different system called "Viewer" and "Commenter" roles. You share the file and set each person's permission level rather than protecting the file itself. If you need read-only behavior in Google Sheets, share the file as "Viewer" only.