You can protect an Excel spreadsheet with a password in three main ways: locking the entire file, protecting a specific sheet from edits, or restricting workbook structure changes. Each method serves a different purpose, and choosing the right one depends on what you are actually trying to protect.

Why Protect an Excel Spreadsheet?

Excel spreadsheets often carry sensitive information that should not be freely accessible. Financial models, HR records, client pricing, payroll data, and board reports all warrant protection. Even internally, not everyone on your team needs to edit every file. Password protection helps you control who can open, change, or restructure your data.

It also reduces the risk of accidental edits. A protected sheet prevents a team member from overwriting a formula they did not know was there.

Three Types of Excel Protection

Before you start clicking, it helps to understand what each protection type actually does.

• File-level password: Prevents anyone from opening the file without the correct password. This is the most secure option for confidential documents.
• Sheet protection: Allows the file to open freely, but restricts editing on a specific worksheet. You can choose which cells remain editable and which stay locked.
• Workbook structure protection: Stops users from adding, deleting, renaming, or moving sheets within the workbook. Useful when your sheet layout is critical to how the file works.

How to Password-Protect the Entire Excel File

This method requires a password just to open the file. Follow these steps in Microsoft Excel for Windows or Mac.

1. Open the workbook you want to protect.
2. Click File in the top menu.
3. Select Info, then click Protect Workbook.
4. Choose Encrypt with Password.
5. Enter a strong password and click OK.
6. Re-enter the password to confirm, then click OK.
7. Save the file. The password takes effect immediately.

Anyone who tries to open the file without the password will be blocked. Store the password somewhere secure, such as a business password manager. There is no recovery option if you lose it.

How to Protect a Specific Sheet from Editing

This is the most practical option for shared workbooks. You can lock the whole sheet or allow users to edit specific cells while everything else stays protected.

Lock the entire sheet

1. Right-click the sheet tab at the bottom of your workbook.
2. Select Protect Sheet.
3. Enter an optional password and click OK.

Allow certain cells to remain editable

1. Select the cells you want users to be able to edit.
2. Right-click and choose Format Cells.
3. Go to the Protection tab and untick Locked.
4. Click OK.
5. Now right-click the sheet tab and select Protect Sheet.
6. Set a password and click OK.

Only the cells you unlocked in step three will be editable. Everything else will be read-only.

How to Protect Workbook Structure

If you want to prevent users from adding or deleting sheets, use workbook structure protection.

1. Click Review in the top ribbon.
2. Select Protect Workbook.
3. Tick the Structure checkbox.
4. Enter an optional password and click OK.

This does not prevent editing of cell content. It only controls the workbook’s sheet layout.

How to Allow Specific People to Edit Locked Cells

In some cases, you need certain users to have edit access while others are restricted. Excel supports this through the “Allow Edit Ranges” feature.

1. Click the Review tab.
2. Select Allow Edit Ranges (Windows only).
3. Click New and define the cell range.
4. Set a range password or use Windows permissions to grant specific users access.
5. Click Protect Sheet to finalise.

Users with the range password can edit that specific area without unlocking the whole sheet.

Important: Password Protection Is Not Full Encryption

This is worth being honest about. Excel’s file-level password uses AES-256 encryption when you use “Encrypt with Password,” which is genuinely strong. However, sheet and workbook structure protection is much weaker. Both can be removed using freely available online tools or by someone with basic technical knowledge.

Sheet protection is designed to prevent accidental changes, not to secure classified data. If you are protecting truly sensitive information, use SharePoint permissions or Microsoft Purview sensitivity labels instead. Do not rely on sheet protection alone for compliance or legal obligations.

How Microsoft Copilot Can Help

If you use Microsoft 365 Copilot, it can assist with your Excel protection decisions in a practical way. Ask Copilot which cells in your model contain formulas that should be locked, and it can identify them quickly. You can also ask Copilot to document your protection policy in plain language, which is useful for onboarding new team members or for compliance records. It will not apply the protection itself, but it can speed up the planning process considerably.

When to Use SharePoint Permissions Instead

Excel password protection is a file-level control. It travels with the file, which creates risk when files are emailed or copied to personal devices. SharePoint permissions stay on the server side. They are more reliable, easier to audit, and do not depend on users handling passwords responsibly.

Use SharePoint permissions when:

• Multiple people need access at different permission levels
• You need an audit trail of who accessed the file
• The file contains data subject to compliance requirements
• You cannot risk the password being shared or lost

SharePoint also works with Microsoft Purview sensitivity labels, which apply persistent protection regardless of where the file ends up.

Frequently Asked Questions

Can I remove an Excel password if I forget it?

For file-level encryption, no. There is no official recovery option. This is why a business password manager is essential. For sheet protection, the password is much easier to bypass, which is why it should not be treated as a security measure for sensitive data.

Does Excel password protection work on Mac?

File-level encryption works on both Windows and Mac. The “Allow Edit Ranges” feature for specific user permissions is only available on Windows versions of Excel.

Is password-protecting a spreadsheet enough for compliance?

Generally, no. Compliance frameworks like the Australian Privacy Act typically require access controls, audit trails, and data classification, none of which Excel password protection provides on its own. Speak with your IT provider about sensitivity labels and SharePoint governance.

Can I protect an Excel file shared on OneDrive or SharePoint?

Yes, but it is better to use SharePoint’s built-in permissions rather than file-level passwords for shared files. SharePoint permissions are centrally managed and revocable without touching the file itself.

Need Help Securing Your Business Data?

Excel protection is a starting point, but a proper data security strategy covers far more. Otto IT helps professional services businesses build secure, manageable Microsoft 365 environments, including SharePoint governance, Purview sensitivity labels, and access control reviews.

Book a free 15-minute call with our team to talk through your current setup and where the gaps might be.