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

A read-only Excel file is one that opens for viewing and calculating, but won't let anyone save changes back to the original. When someone tries to edit a cell and close the file, Excel asks them to save as a new file instead — the original stays untouched. This is useful when you're sharing a budget template, a pricing list, or any spreadsheet you don't want accidentally (or intentionally) altered.

Read-only is not a password lock. Someone determined enough can still edit the file — they just have to save it under a new name first. If you need actual security against someone deliberately changing your data, you'll want file permissions or password protection instead. But for casual sharing and preventing accidental edits, read-only works well and takes about 30 seconds to set up.

Key Takeaways

  • You can mark a file read-only through Windows File Properties (right-click the file, select Properties, check "Read-only" under Attributes) or through Mac Finder (Get Info, check "Locked").
  • Read-only prevents accidental changes but does not stop someone from deliberately saving the file under a new name and editing it.
  • Excel also has an "Open as Read-Only" option inside the program itself, which you can use without changing the file's properties.
  • If you need stronger protection, use Excel's password features or file permissions through your operating system or cloud storage.
  • The read-only status stays with the file until you remove it, so shared copies will also open as read-only.

Setting read-only through Windows File Properties

On Windows, the simplest method is to change the file's properties. Right-click the Excel file, then select Properties from the menu that appears. At the bottom of the General tab, you'll see a section labeled Attributes. Check the box next to Read-only, then click Apply and OK.

The file is now read-only. When someone opens it in Excel and tries to save changes, they'll see a dialog asking whether to save as a new file or discard changes. The original file remains unchanged. If you later need to edit it yourself, go back to Properties and uncheck the Read-only box.

This method works for any file type, not just Excel. The read-only status travels with the file if you email it or move it to a shared folder, so recipients will see the same behavior.

Setting read-only on a Mac

On Mac, open Finder and locate your Excel file. Right-click it and select Get Info. A window opens showing the file's details. Near the bottom, you'll see a checkbox labeled Locked. Check this box, then close the window.

The file is now locked. When opened in Excel, it will behave the same way as a Windows read-only file — edits are possible, but saving changes requires saving as a new file. To unlock it later, return to Get Info and uncheck the Locked box.

Using Excel's Open as Read-Only feature

If you don't want to change the file's properties but still want to open it safely, Excel has a built-in option. Open Excel, go to File, then Open. Browse to your file, but instead of double-clicking it, right-click it and select Open as Read-Only (on Windows) or click the file once and look for an "Open Read-Only" button (on Mac).

This approach doesn't change the file itself — only your current session opens it as read-only. If someone else opens the same file normally, they'll be able to edit it. This is useful when you're working with a shared file and want to make sure you don't accidentally overwrite someone else's changes.

Protecting with a password instead

Read-only is convenient but not secure. If you need to actually prevent edits, use Excel's password feature. Open the file, go to File, then Info. Click Protect Workbook and select Encrypt with Password. Enter a password, confirm it, and save the file.

Now the file requires a password to open at all. This is stronger than read-only because no one can view or edit the file without the password. The tradeoff is that you have to share the password separately, and if you forget it, you cannot recover the file.

Another option is Protect Sheet, which lets people view and use the spreadsheet but prevents them from editing specific cells or changing the sheet structure. This is useful for templates where you want users to fill in certain cells but not alter formulas or formatting.

Read-only with cloud storage

If you store your file in OneDrive, Google Drive, or Dropbox, you can set permissions directly in the cloud service. In OneDrive or Google Drive, right-click the file and select Share. When you invite people, choose Can view instead of Can edit. They'll see the file but won't be able to make changes.

This method is often better than file-level read-only because the restriction lives in the cloud service itself, not just on the file. If someone downloads the file, they'll still have a copy they can edit locally, but the version in the cloud stays protected. You can also change permissions later without touching the file itself.

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

When a read-only file opens in Excel, the title bar usually shows [Read-Only] next to the filename. The user can click cells, see formulas, and use the spreadsheet normally. But if they try to change a cell and then close the file, Excel shows a dialog: "Do you want to save the changes you made to [filename]?"

If they click Save, Excel prompts them to save as a new file with a different name. The original file is never modified. If they click Don't Save, the changes are discarded and the file closes unchanged. Some users find this annoying, which is why read-only works best for files you're sharing as templates or reference materials, not for collaborative work.

Frequently Asked Questions

Can someone remove the read-only status from a file I sent them?

Yes, if they have access to the file's properties. On Windows, they can right-click, go to Properties, and uncheck Read-only. On Mac, they can Get Info and uncheck Locked. Read-only is a convenience feature, not a security measure. If you need to prevent changes, use a password or cloud storage permissions instead.

Will read-only stop formulas from calculating?

No. A read-only file calculates normally. Users can change input cells and see the results update. They just can't save those changes back to the original file — they have to save as a new file. This makes read-only useful for templates where you want people to experiment without altering your master copy.

What's the difference between read-only and password protection?

Read-only prevents accidental saves to the original file but doesn't stop someone from deliberately saving a copy and editing it. Password protection requires a password just to open the file, which is stronger but less convenient. For most sharing situations, read-only is enough. Use password protection only when the file contains sensitive information.

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

Yes. The read-only status is part of the file's properties, so it travels with the file through email, cloud storage, or any other transfer method. When the recipient opens it, they'll see the same read-only behavior you set up.

Can I make just one sheet in a workbook read-only?

Yes, using Protect Sheet. Open the file, right-click the sheet tab at the bottom, and select Protect Sheet. You can then choose which cells users can edit and which they cannot. This is more flexible than making the entire file read-only because you can allow editing in specific areas while locking down formulas or structure.