How to Make an Excel Spreadsheet Read Only

Spreadsheets have a way of getting quietly destroyed. Someone fat-fingers a formula, drags a cell over a header, or “fixes” a number they didn’t understand, and suddenly a report that took hours to build is wrong and nobody notices until a meeting goes sideways. Locking a workbook down to read-only mode is one of the simplest, most underused ways to prevent that.

The Three Real Ways to Make Excel Read-Only (and Why They’re Different)

People often say “make it read-only” as if there’s one setting, but Excel actually offers three distinct mechanisms, each with a different level of enforcement. Mixing them up is why so many users end up either over-restricting collaborators or under-protecting sensitive data.

Here’s the practical breakdown:

• Mark as Final – A soft flag that labels the file as complete and puts it into a read-only viewing state. It’s polite, not secure — one click (“Edit Anyway”) undoes it.
• Save As with a password to modify – A genuine barrier. Anyone without the password can only open the file in read-only mode; they can view but not save changes under the original name.
• Sheet/Workbook Protection (Review tab) – Locks specific cells, formulas, or the workbook’s structure (tabs, sheet order) while still allowing some editing, like filling in designated input fields.

Industry analysts who track enterprise spreadsheet risk consistently note that most “accidental data loss” incidents in shared workbooks trace back to missing or misconfigured protection settings, not malicious tampering.

Knowing which of these three you actually need is the first decision to make before touching any menu.

Method 1: Mark as Final (Quick, But Weak)

Mark as Final is built for one scenario: you’re done editing, and you want to signal that to anyone who opens the file next. It’s the digital equivalent of stamping “FINAL DRAFT” on a printed document.

How to apply it

1. Open the workbook you want to protect.
2. Click File, then Info.
3. Select Protect Workbook, then choose Mark as Final.
4. Save the file when prompted.

Once applied, the ribbon disables editing commands and a yellow banner appears at the top reading “Marked as Final.” But here’s the catch: any user can click Edit Anyway in that same banner and instantly regain full editing rights. No password, no permission check.

That makes Mark as Final useful for internal signaling — telling teammates “this version is locked in” — but useless as an actual security control. If you’re sending a file externally and expect it to stay untouched, skip this method entirely and use one of the two below instead.

Method 2: Password-Protect the File as Read-Only (Recommended for Sharing)

This is the option most people actually want when they ask how to “make a spreadsheet read only.” It creates a real gate: recipients can open and view the file freely, but saving changes requires a password.

Setting it up

1. Open the file, then go to File > Save As (or press F12 for Save As dialog).
2. Click Tools next to the Save button, and choose General Options.
3. In the dialog, you’ll see two separate password fields: Password to open and Password to modify.
4. Enter a password only in the Password to modify field — leave “Password to open” blank if you want anyone to be able to view it.
5. There’s also a checkbox for Read-only recommended, which pops up a gentle suggestion (not a hard block) when the file opens.
6. Click OK, confirm the password, and save.

The distinction between these two password fields trips people up constantly. A “Password to open” encrypts the entire file so it can’t even be viewed without the correct code. A “Password to modify” lets anyone open and read the file but blocks saving over the original unless they enter the password — that’s the true read-only behavior most people are after.

If someone doesn’t have the modify password, they can still edit the open copy in Excel’s session — they just can’t overwrite the original file. They’d have to use Save As to store it under a new name, leaving your source file untouched.

Method 3: Protect Sheet and Protect Workbook (Best for Formulas and Templates)

Sometimes full read-only access is too restrictive. Think of a budgeting template where users should type numbers into specific input cells, but the formulas calculating totals must never be touched. That’s where cell-level protection through the Review tab comes in.

Step-by-step for locking specific cells

1. Select the cells you want to remain editable (the input fields).
2. Right-click, choose Format Cells, go to the Protection tab, and uncheck Locked.
3. Everything else in the sheet stays locked by default.
4. Go to Review > Protect Sheet.
5. Set a password (optional but recommended), and choose what limited actions users are still allowed to do — like sorting, using AutoFilter, or formatting cells.
6. Click OK and confirm the password.

This is especially important in sheets full of calculations. If you’ve ever dealt with an issue where an Excel formula is not calculating correctly after someone edited a cell they weren’t supposed to touch, sheet protection is usually the fix that should have been in place from the start. Locking formula cells prevents accidental overwrites that silently break downstream calculations.

Protecting workbook structure

There’s a second layer above sheet protection: workbook structure protection. This stops users from adding, deleting, renaming, hiding, or reordering sheet tabs.

• Go to Review > Protect Workbook.
• Check the box for Structure.
• Set an optional password.
• Click OK.

This matters more than people expect in multi-tab financial models, where a hidden calculation sheet or a specific tab order is load-bearing for the whole file. If a colleague accidentally deletes a hidden reference tab, formulas across the entire workbook can break at once.

Advanced Scenarios: Read-Only for Teams, Cloud Files, and Templates

Local password protection works fine for one-off files, but most spreadsheets today live in SharePoint, OneDrive, or Google Sheets-adjacent shared environments. The read-only playbook shifts slightly there.

For files stored in SharePoint or OneDrive

• Right-click the file in the library or OneDrive folder.
• Select Manage Access or Version History settings.
• Assign users the Can View permission instead of Can Edit.
• This is enforced at the platform level, independent of any Excel-native password.

This is generally more reliable than file-level passwords for team environments because IT admins can audit and revoke access centrally, and it doesn’t rely on every collaborator remembering a shared password.

For reusable templates

If you’re building a spreadsheet that others will fill out repeatedly — a budget tracker, an intake form, a scheduling grid — consider saving it as an actual .xltx template file rather than relying on protection settings alone. When users open a template, Excel automatically creates a new untitled copy, so there’s no risk of them overwriting your master file at all.

This approach pairs well with locked input cells. For example, a template built around a profit margin formula can have the formula cells locked and protected while leaving revenue and cost cells open for data entry — combining the template safety net with cell-level protection.

Common pitfalls to avoid

• Forgetting the password – Excel’s built-in password protection has no recovery mechanism in current versions; a forgotten modify-password can permanently lock you out of easy editing.
• Protecting the sheet before formatting is finished – Locked cells can’t be resized, reformatted, or have new formulas added without unprotecting first, which slows down last-minute changes.
• Assuming Mark as Final travels with the file forever – It’s stored as document metadata and can be stripped or bypassed easily, so never rely on it for anything sensitive.
• Confusing sheet protection with workbook protection – Locking cells on one sheet does nothing to stop someone from deleting that entire sheet if workbook structure isn’t also protected.

Conclusion

Making an Excel spreadsheet truly read-only isn’t a single checkbox — it’s a decision about how much friction you actually want. Mark as Final is a courtesy flag for a file you consider done. A modify-password through Save As creates a genuine, if basic, security barrier for anyone outside your organization. Sheet and workbook protection through the Review tab is the right tool when you need collaborators to input data without touching formulas, structure, or formatting underneath.

The mistake most people make is picking whichever option pops up first in the File menu without asking what they’re actually protecting against — accidental edits from a coworker, or deliberate tampering from an outside party need very different levels of lockdown. Match the method to the actual threat, and you’ll stop losing hours to spreadsheets that got quietly broken by someone who didn’t mean to break them.

FAQ