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

A read-only file is one that people can open and look at, but cannot save changes to. When someone opens your Excel file in read-only mode, they can read every cell, copy data, print it, and even create their own version with edits — but they cannot overwrite your original file. Excel will warn them if they try to save, and force them to save under a different name instead.

You use read-only when you want to share information without risking accidental changes. A manager might send a budget template as read-only so team members see the structure but cannot alter the formulas. A department might lock a master contact list so people can copy phone numbers but cannot delete entries by mistake.

Read-only is not encryption or password protection — anyone determined enough can remove it. It is a courtesy barrier that stops casual edits and makes it obvious that changes are not supposed to happen to this particular file.

Key Takeaways

  • You can mark a file read-only through Windows file properties, Mac Finder, or directly inside Excel using the Info tab.
  • Read-only stops accidental changes but does not prevent someone from removing the read-only status if they have access to the file.
  • When someone opens a read-only file in Excel, they see a yellow banner at the top offering to enable editing or save a copy.
  • If you need stronger protection — such as preventing specific people from editing — use Excel's password-protected sheets or workbook protection instead.

Making a file read-only in Windows

Right-click the Excel file on your computer and select Properties from the menu. At the bottom of the General tab, you will see a checkbox labeled Read-only. Check that box and click explore, then OK.

The file icon will not change appearance, but Windows now prevents any program from saving changes directly to it. When someone opens it in Excel, they will see a notification bar asking whether to enable editing or create a copy. If they click Edit Anyway, Excel will let them make changes, but when they try to save, Excel will force them to save as a new file instead.

To remove read-only status later, open Properties again, uncheck the box, and click explore. You need to be logged in as the file owner or an administrator to change this setting.

Making a file read-only on a Mac

Open Finder and locate your Excel file. Right-click it and select Get Info. Near the bottom of the window, find the checkbox labeled Locked and check it. Close the Info window.

On a Mac, a locked file works slightly differently than Windows read-only. When someone tries to save changes to a locked file, they will see a dialog asking whether to save a duplicate, replace the original (which requires their password), or cancel. Most people will choose to save a duplicate, which leaves your original untouched.

To unlock the file later, open Get Info again, uncheck Locked, and close the window.

Making a file read-only directly in Excel

You can also set read-only status from inside Excel itself. Open the file, then click File in the top left. On Windows, click Info, then look for a button that says Protect Workbook or Protect Sheet. On Mac, click File and look for Protect Workbook in the menu.

If you see Protect Sheet, that locks individual sheets but allows the workbook itself to be edited. If you see Protect Workbook, that locks the structure of the entire file — people cannot add or delete sheets. Neither of these is the same as read-only; they are stronger protections that require a password to remove.

For true read-only without a password, use the file properties method described above instead. Excel's protection features are meant for situations where you want to prevent specific edits and require a password to undo them.

What happens when someone opens a read-only file

When a person opens your read-only Excel file, they will see a yellow banner across the top that says something like "This file is read-only" with an Edit Anyway button. They can click that button to make changes, but those changes only exist in their current session. The moment they try to save, Excel will say the file is read-only and offer to save as a new file instead.

They can still copy data, print the file, and create formulas — they just cannot overwrite the original. This is useful for shared files where you want people to reference the data but not alter it by mistake.

When read-only is not enough protection

Read-only stops accidental changes, but it does not stop intentional ones. Anyone with access to the file can remove the read-only status through file properties or Finder, then edit and save normally. If you need to prevent specific people from editing — such as keeping a password-protected budget that only managers can change — use Protect Sheet or Protect Workbook instead, which requires a password to remove.

If you are sharing the file through email or a cloud service like OneDrive or Google Drive, those services have their own permission systems. You can set a file to "view only" in OneDrive, which is stronger than read-only because the cloud service enforces it, not just the file itself. For the strongest protection, use a cloud service's built-in sharing permissions rather than relying on file read-only status alone.

Frequently Asked Questions

Can I remove read-only status from a file someone else marked as read-only?

Yes. Open file properties (Windows) or Get Info (Mac) and uncheck the read-only or locked box. You do not need a password. Read-only is a courtesy barrier, not a security feature. If you need to prevent someone from removing protection, use Excel's password-protected sheet or workbook protection instead.

Does read-only prevent someone from copying data out of the file?

No. Read-only only prevents saving changes back to the original file. Someone can still select cells, copy them, and paste them into a new spreadsheet. If you need to prevent copying, you would need to use Excel's sheet protection with a password, though that is also not foolproof.

What is the difference between read-only and protected sheets?

Read-only prevents any changes from being saved to the original file. Protected sheets let you choose which cells people can edit and which they cannot, and you can require a password to unprotect. Use read-only for "do not change this file," and protected sheets when you want to allow some edits but lock down specific areas.

If I upload a read-only file to OneDrive or Google Drive, does it stay read-only?

The file itself stays read-only, but cloud services have their own permission system. Someone with edit access to the OneDrive folder can read the file, remove read-only status, and re-upload it. For cloud sharing, use the service's built-in sharing permissions (view-only, edit, etc.) rather than relying on the file's read-only status.

Can I make a file read-only and password-protected at the same time?

Yes. You can set the file to read-only through properties, and separately use Excel's Protect Sheet or Protect Workbook feature with a password. This gives you two layers: read-only stops casual changes, and password protection stops intentional ones. However, this is stronger than most situations need.