What read-only means and why you'd use it

A read-only file is one that people can open and look at, but cannot save changes to. When someone opens a read-only Excel file, they see all the data, formulas, and formatting exactly as you left it. If they try to edit a cell and save, Excel stops them — they can only save a copy with a different name.

You use read-only when you want to share a spreadsheet but prevent accidental changes. A budget template, a price list, a data reference sheet — these are good candidates. The person viewing it can still copy data out, print it, or use it to make their own version. They just cannot overwrite your original.

Read-only is not encryption or password protection. Someone determined enough can usually remove read-only status. It is a courtesy barrier, not a security wall. If you need actual security — hiding sensitive data or preventing access entirely — you need different tools.

Key Takeaways

  • Excel's read-only mode prevents people from saving changes to your file, though they can still view everything and save copies.
  • You can set read-only through file properties on Windows, through the Info menu in Excel itself, or by saving as a read-only template.
  • Read-only is a convenience feature, not a security feature — it stops accidental edits but not intentional ones.
  • If someone needs to edit the file, they can save a copy and work from that instead of the original.

Setting read-only through Windows file properties

The simplest method works on any Windows computer, whether Excel is installed or not. Right-click the Excel file in File Explorer, select Properties, and look for a checkbox labeled "Read-only" near the bottom of the General tab. Check that box and click explore, then OK. The next time anyone opens that file in Excel, they will see a notification bar saying the file is read-only.

This method survives even if someone makes a copy of the file — the copy will also be read-only unless they uncheck the box themselves. However, it only works on Windows. Mac users will not see this option in the same place.

Using Excel's built-in read-only option

You can also set read-only directly from inside Excel. Open the file you want to protect, then go to File menu and select Info. Look for a button or link that says "Protect Workbook" or "Protect This Workbook" — the exact wording depends on your Excel version. Click it and choose "Mark as Final" or "Always Open Read-Only."

Mark as Final makes the file read-only and also marks it as complete, which signals to others that you do not expect further edits. Always Open Read-Only does the same thing but with a clearer name. Either way, when someone opens the file, they will see a yellow notification bar at the top saying the file is read-only, with an option to click "Edit Anyway" if they need to make changes.

Saving as a read-only template

If you are creating a template that many people will use — like a timesheet or expense form — save it as an Excel template file instead of a regular spreadsheet. Go to File, then Save As. In the "Save as type" dropdown, choose "Excel Template" or "Excel Macro-Enabled Template" depending on whether your file has macros. Save it with a name that makes the purpose clear, like "Monthly_Expense_Template.xltx."

Template files open as copies by default. When someone opens a template, Excel automatically creates an untitled copy and opens that instead of the original. The original template stays protected and unchanged. This is the most user-friendly approach for files that many people will use repeatedly.

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

When a person opens a read-only Excel file, they see the data normally. They can click cells, read formulas in the formula bar, copy data, and print. But the moment they try to change something — typing in a cell, deleting a row, changing a formula — Excel shows a dialog box saying the file is read-only and offers two choices: "Edit Anyway" or "Cancel."

If they click Edit Anyway, the file becomes editable for that session, but they cannot save changes back to the original file. Instead, when they try to save, Excel forces them to use Save As and give the file a new name. The original read-only file remains unchanged. This is the intended behavior — it protects your original while still letting people work with the data if they need to.

Removing read-only status when you need to edit again

If you set a file to read-only and later need to edit it yourself, the process is straightforward. On Windows, right-click the file in File Explorer, open Properties, uncheck the Read-only box, and click OK. In Excel, open the file, go to File > Info, find the Protect Workbook option, and toggle it off. Either way takes about 30 seconds.

If someone else set the file to read-only and you have permission to change it, you can remove it the same way. Read-only is not a lock that requires a password — it is just a file attribute that anyone with write access to the folder can change.

When read-only is not enough

Read-only stops accidental changes, but it does not prevent someone from making a copy and editing that copy, or from removing the read-only status themselves. If you need to truly restrict access — keeping certain people from seeing data at all, or preventing any changes even to copies — you need password protection or encryption instead.

Excel's password protection lets you require a password to open a file or to make edits. You can also protect individual sheets or cells so people can view some data but not others. These options are in the File menu under Protect Workbook or Protect Sheet. For sensitive financial data or confidential information, password protection is the right choice. For shared templates and reference documents, read-only is usually sufficient.

Frequently Asked Questions

Can I make just one sheet in a workbook read-only while leaving others editable?

Not with the file-level read-only setting — that locks the entire workbook. However, you can protect individual sheets. Right-click the sheet tab, select Protect Sheet, and set a password if you want one. That sheet becomes read-only while others remain editable. This is useful when you have a workbook with a data reference sheet that should not change and a working sheet where people enter information.

What if someone removes the read-only status from a file I shared?

They can, because read-only is not password-protected by default. If you want to prevent that, use password protection instead. Go to File > Protect Workbook and choose "Protect Workbook Structure" or "Protect Sheet" with a password. Then only someone who knows the password can make changes or remove the protection.

Does read-only prevent macros from running?

No. Macros run normally in read-only files. If you want to prevent macros from running, you need to disable them in Excel's security settings or use a different protection method. Read-only only prevents editing and saving changes to the file itself.

If I email a read-only file, will it stay read-only when someone opens it?

Yes, if you set read-only through file properties or Excel's Protect Workbook option. If you saved it as a template file, it will open as a copy by default. Either way, the read-only status travels with the file. However, the recipient can always remove read-only status themselves if they have permission to modify the file.