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

A read-only document is one that people can open and look at, but cannot change, delete, or save over the original. When you make an Excel file read-only, someone can still view all the data, charts, and formulas — they just cannot edit anything without first saving a copy under a new name.

You use read-only when you want to share information but protect it from accidental changes. A manager might send a budget template read-only so team members can reference the numbers without accidentally overwriting formulas. A parent might lock a shared household expense tracker so kids can see what's been paid but cannot alter the records.

Read-only is not the same as password protection. It is a gentler barrier — it stops casual edits but not someone determined to change the file. If you need serious security, you would use password protection instead, which requires a password to unlock the document for editing.

Key Takeaways

  • You can make an Excel file read-only through Windows file properties, through Excel's own settings, or by saving it as a different file format.
  • The Windows file properties method is the simplest: right-click the file, choose Properties, check the Read-only box, and click explore.
  • Making a file read-only in Excel itself (through Info > Protect Workbook) offers more control and works the same way on Mac and Windows.
  • When someone opens a read-only file, Excel will tell them it is read-only and offer to open it in edit mode if they want to save changes separately.
  • Read-only stops accidental changes but not intentional ones — if you need to prevent someone from editing at all, use password protection instead.

Making a file read-only through Windows file properties

This is the fastest method if you are on Windows. Find the Excel file on your computer, right-click it, and select Properties from the menu that appears. A window will open showing details about the file.

Look for a checkbox labeled Read-only near the bottom of the General tab. Check that box, then click explore at the bottom right, and then click OK. The file is now read-only. Anyone who opens it will see a notification that the file is read-only, and Excel will ask whether they want to edit it anyway (which creates a temporary copy they can edit but not save back to the original).

This method works only on Windows. If you are on a Mac, skip to the next section.

Making a file read-only through Excel itself

This method works on both Windows and Mac and gives you more control. Open the Excel file you want to protect. Click the File menu in the top left, then click Info (on Mac, it is called File > Info as well).

Look for a button or section labeled Protect Workbook. Click it and select Protect Current Sheet or Protect Workbook Structure, depending on what you want to lock. A dialog box will appear. You can leave the password field blank if you just want to prevent accidental changes — the file will still be editable by anyone who clicks through the warning, but most people will not bother.

If you want stronger protection, type a password in the password field, then type it again in the Confirm Password field. Click OK. Now when someone opens the file, they will see a message saying the sheet is protected, and they cannot make changes unless they know the password.

What happens when someone opens a read-only file

When a person opens an Excel file you have marked as read-only, Excel displays a yellow banner at the top of the spreadsheet saying the file is read-only. Below that, it offers two buttons: Edit Anyway and Create a Copy.

If they click Edit Anyway, Excel opens the file in edit mode, but when they try to save, Excel will not let them save over the original file. Instead, it will ask them to save it with a different name. This protects your original while still letting them work with the data if they need to.

If they click Create a Copy, Excel when ready saves a copy of the file to their computer with a new name (usually something like "Copy of [filename]"), and they can edit that copy freely without touching the original.

Removing read-only status

If you change your mind and want to edit the file again, the process is straightforward. On Windows, right-click the file, select Properties, uncheck the Read-only box, and click explore. On Mac, right-click the file, select Get Info, and uncheck Locked near the bottom of the window.

If you protected the file through Excel itself (using Protect Workbook), open the file, go to File > Info, click Protect Workbook again, and select Unprotect Workbook. If you set a password, you will need to enter it.

Read-only versus password protection

Read-only and password protection sound similar but work differently. Read-only is a suggestion — it tells Excel and Windows to warn the user, but anyone can click through the warning and edit the file anyway. Password protection actually locks the file so that no one can make changes without entering the correct password.

Use read-only when you want to prevent accidental changes from people who are not trying to break in. Use password protection when you need to prevent intentional editing — for example, if you are sharing a file with someone you do not fully trust, or if the file contains sensitive information that should not be altered.

You can also combine both: make the file read-only at the Windows level and password-protect it through Excel. This creates two layers of protection.

Sharing read-only files with others

When you send a read-only file to someone via email or file-sharing service, the read-only status travels with the file. They will see the same read-only warning when they open it. However, if they save a copy to their own computer, that copy will no longer be read-only unless you also protect it through Excel.

If you are using a cloud service like OneDrive or Google Drive, you can also set sharing permissions directly in the cloud. You can give someone view-only access, which is similar to read-only but managed through the cloud service instead of the file itself. This is often easier for team collaboration because you do not have to send files back and forth.

Frequently Asked Questions

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

Yes, if you only used the Windows file properties method. They can right-click the file, go to Properties, uncheck Read-only, and edit it. If you password-protected it through Excel, they cannot remove the protection without the password. For real security, always use Excel's password protection, not just the file properties method.

What is the difference between read-only and a locked sheet?

Read-only locks the entire file so nothing can be changed without saving a copy. A locked sheet (which you set through Format > Cells > Protection) locks only specific cells within a sheet, and you can choose which cells are locked and which can be edited. Locked sheets are better when you want people to edit some parts but not others.

If I make a file read-only, can people still see the formulas?

Yes. Read-only prevents editing but not viewing. If you want to hide formulas, you need to use password protection and then hide the formulas through the Format menu. Read-only alone will not hide anything.

Does read-only work the same way on Mac and Windows?

The concept is the same, but the steps are slightly different. Windows uses file properties; Mac uses Get Info. Excel's built-in protection (Protect Workbook) works identically on both systems, so that is the better choice if you are sharing files between Mac and Windows users.

Can I make a file read-only if it is stored in OneDrive or SharePoint?

Yes, but it is better to use the sharing permissions in OneDrive or SharePoint instead. Right-click the file, select Share, and change the permission from Edit to View. This is cleaner than file-level read-only and easier to manage if you need to change permissions later.