The quickest way to make an Excel file read-only

To make an Excel file read-only on Windows, right-click the file in File Explorer, select Properties, check the Read-only box under the General tab, and click Apply. On Mac, select the file in Finder, press Command+I to open Get Info, and check Locked under General. This prevents anyone from saving changes to the file without first removing the read-only status — though they can still open it and save a copy under a different name.

If you want to protect the file from being edited at all without a password, you can also set a password inside Excel itself. This method works across Windows and Mac and gives you more control over what people can and cannot do with the spreadsheet.

Key Takeaways

  • The file properties method (right-click Properties on Windows, Command+I on Mac) prevents saving over the original file but allows users to save copies.
  • Excel's built-in password protection lets you set a password that must be entered before anyone can edit the spreadsheet.
  • Read-only status set through file properties can be removed by anyone with access to the file — it is not a security measure, just a reminder.
  • You can allow specific ranges to be edited while keeping the rest of the sheet locked, useful for forms where only certain cells should change.

Making a file read-only through file properties

This is the simplest method and works on both Windows and Mac. On Windows, locate your Excel file in File Explorer, right-click it, and select Properties. In the window that opens, look for the Read-only checkbox in the General tab. Check this box and click Apply, then OK. The file icon will now show a small padlock symbol.

On Mac, find your Excel file in Finder, right-click it, and select Get Info (or press Command+I). Scroll down to the General section and check the Locked checkbox. Close the window. When someone tries to save changes to this file, Excel will prompt them to save as a new file instead.

This method is not a security feature — anyone can uncheck the read-only box the same way you checked it. It is a courtesy flag that prevents accidental overwrites and reminds users that this is a master copy.

Password-protecting an Excel file

To require a password before anyone can edit your spreadsheet, open the file in Excel and go to File > Info (Windows) or File > Properties (Mac). Look for a button labeled Protect Workbook or Protect Sheet. Click it and select Encrypt with Password.

Excel will ask you to enter a password twice. Once you save the file, anyone who opens it will need to type this password before they can make any changes. If they try to edit without the password, Excel will open the file in read-only mode automatically. They can still view the data and save a copy, but they cannot alter the original.

Keep your password somewhere safe — if you forget it, you cannot recover it, and the file will remain locked. This method works on both Windows and Mac and is much stronger than the file properties method because the file itself is encrypted.

Locking specific cells while leaving others editable

If you want people to fill in certain cells (like a form) but not change others, you can lock individual cells or ranges. First, select all the cells you want to protect. On Windows, go to Home > Format Cells (or right-click and select Format Cells). On Mac, right-click and select Format Cells. Go to the Protection tab and check Locked.

Now select only the cells you want people to edit, open Format Cells again, go to the Protection tab, and uncheck Locked. This marks those cells as editable. Then go to Review > Protect Sheet (Windows) or Tools > Protect Sheet (Mac), set a password if you want one, and click OK. Now only the unlocked cells can be edited.

This approach is useful for templates and forms where you want users to fill in data but not change formulas, headers, or calculations. If you set a password, users will need it to unprotect the sheet later.

Protecting the entire workbook structure

You can also prevent people from adding, deleting, or renaming sheets within a workbook. Go to Review > Protect Workbook (Windows) or Tools > Protect Workbook (Mac). A dialog will appear asking whether you want to protect the structure (sheet tabs) or the windows (window size and position). Check Structure if you want to lock the sheets themselves.

You can set a password here too, though it is optional. Once protected, users cannot right-click sheet tabs to insert, delete, or move sheets. They can still edit the data inside each sheet unless you have also locked individual cells or the entire sheet.

Removing read-only status

If a file is marked read-only through file properties, you can remove that status the same way you set it. Right-click the file, select Properties (Windows) or Get Info (Mac), and uncheck the Read-only or Locked box.

If the file is password-protected inside Excel, you will need the password to remove the protection. Open the file, enter the password when prompted, then go to Review > Unprotect Sheet or Unprotect Workbook and enter the password again. Without the password, you cannot remove the protection.

Frequently Asked Questions

Can someone edit a read-only file if they really want to?

Yes, if the read-only status is set through file properties. They can uncheck the read-only box themselves or save a copy of the file under a new name and edit that. Password protection inside Excel is stronger — they cannot edit without the password, though they can still open and view the file.

What happens if I forget the password to my protected Excel file?

Excel does not have a password recovery option. If you forget the password, you cannot unprotect the file or edit it. You will need to use the original unprotected version if you have one, or recreate the file from scratch.

Can I make a file read-only on Google Sheets or OneDrive?

Yes, but the method is different. In Google Sheets, click the Share button and set permissions to Viewer instead of Editor. In OneDrive or SharePoint, right-click the file and select Manage access, then change permissions to read-only.

Does read-only protect my file from viruses or malware?

No. Read-only status only prevents editing and saving. It does not protect against malware or unauthorized access. For security, use password protection or store sensitive files in an encrypted folder.

Can I lock a file so people cannot even open it?

Not with Excel's built-in tools. Password protection requires a password to edit, but the file can still be opened and viewed. To prevent people from opening a file at all, you would need to use file encryption at the operating system level or store the file in a password-protected folder.