How to Make an Excel Document Read Only (And When Each Method Makes Sense)
Protecting an Excel file from accidental edits is one of those tasks that sounds simple until you realize there are at least five different ways to do it — and they don't all work the same way. Some lock the whole file, some lock specific sheets, and some just suggest caution without enforcing anything. Understanding the difference matters before you choose.
Why Read-Only Protection Exists in Excel
Excel's read-only options exist to solve different problems. Sometimes you want to prevent yourself from accidentally overwriting a template. Sometimes you're sharing a report and don't want a colleague to edit the data. Sometimes a file contains finalized figures that shouldn't change. Each scenario calls for a slightly different approach.
The key distinction to understand upfront: restricting editing and requiring a password to open are two separate layers of protection in Excel. You can use one, both, or neither.
The Main Methods for Making an Excel File Read Only
1. Mark as Final
Found under File → Info → Protect Workbook → Mark as Final, this option adds a notice at the top of the file telling anyone who opens it that it's been marked as final. Editing is disabled by default when the file opens — but any user can simply click "Edit Anyway" and the restriction disappears.
This is a soft warning, not a real lock. It communicates intent, not enforcement. Useful for internal files where you trust collaborators to respect the flag.
2. Protect Workbook Structure
Under File → Info → Protect Workbook → Protect Workbook Structure, you can set a password that prevents users from adding, deleting, renaming, or moving sheets. This does not prevent editing the content inside those sheets — it only protects the workbook's architecture.
Worth knowing: if you close and reopen the file, the structural protection remains in place until someone enters the password to remove it.
3. Protect Sheet
This is the most commonly used option for restricting what users can do within a specific worksheet. Go to Review → Protect Sheet, set a password, and choose which actions to allow — things like selecting locked cells, formatting, inserting rows, and so on.
By default, all cells are locked when sheet protection is turned on, but you can unlock specific ranges first (via Format Cells → Protection tab → uncheck "Locked") so that certain areas remain editable while everything else is frozen. This is the basis for building forms or templates where only input fields should be changeable.
4. Save with a Read-Only Password
When saving a file, go to File → Save As → Tools → General Options. Here you'll find two password fields:
| Password Type | What It Does |
|---|---|
| Password to open | Requires a password just to view the file |
| Password to modify | Opens the file in read-only mode unless the correct password is entered |
The "Password to modify" option is particularly useful for shared files. Recipients can open and read everything but will be prompted for a password to make changes. If they don't have it, Excel opens the file in read-only mode automatically.
There's also a "Read-only recommended" checkbox in the same dialog — this prompts users to open the file as read-only but doesn't enforce it. Similar in spirit to Mark as Final.
5. File System-Level Read Only 🔒
Outside of Excel entirely, you can set a file to read-only through your operating system. On Windows, right-click the file → Properties → check "Read-only." On macOS, use Get Info and adjust sharing permissions.
When a file is set to read-only at the OS level, Excel will open it in read-only mode and users cannot save changes to the same file name. They can still edit the content in memory and Save As a new copy, so this isn't a security measure — it's a safeguard against overwriting.
Comparing the Methods at a Glance
| Method | Enforced? | Password Required? | Scope |
|---|---|---|---|
| Mark as Final | ❌ No | No | Whole workbook |
| Protect Workbook Structure | ✅ Yes | Optional | Sheet structure only |
| Protect Sheet | ✅ Yes | Optional | Individual sheet content |
| Password to Modify | ✅ Yes | Yes | Whole workbook |
| OS-Level Read Only | ✅ Yes | No | File system |
What About Excel Online and Shared Workbooks?
Excel on the web (via Microsoft 365) handles permissions differently. Access is controlled through SharePoint or OneDrive sharing settings rather than in-file passwords. You can share a link with "Can view" permissions, which prevents editing entirely without touching the file itself.
If you're working within an organization using Microsoft 365, your IT environment may also include Information Rights Management (IRM) policies that apply read-only restrictions at a deeper level — enforced even if the file is downloaded and opened in the desktop app.
What Happens to Formulas and Macros Under Protection?
This trips people up. Protecting a sheet does not hide formulas by default — anyone can click a locked cell and read the formula in the formula bar. If formula confidentiality matters, you need to enable the "Hidden" attribute in Format Cells before applying sheet protection.
Macros (VBA) have their own protection layer under Developer → Visual Basic → Tools → VBAProject Properties → Protection tab, separate from all of the above.
The Variables That Shape Which Method Fits
Which approach makes the most sense depends on factors that vary considerably from one situation to the next:
- Who the file is being shared with — a trusted teammate vs. an external client vs. a public download changes the risk profile entirely
- Whether you need to allow partial editing — templates with input fields need sheet protection with selective unlocking, not a blanket read-only setting
- Whether the file lives on a local drive, a network share, or cloud storage — cloud-based permission systems can make in-file passwords redundant or even create conflicts
- Your version of Excel — some options behave slightly differently across Excel 2016, 2019, 2021, and Microsoft 365
- How technically comfortable your collaborators are — a "read-only recommended" prompt stops the cautious but not the curious
The right combination of these methods depends entirely on your file, your collaborators, and what you actually need to protect — and that picture looks different for everyone.