How to Password Protect an Excel Sheet or Workbook

Protecting your Excel files from accidental edits — or from other people entirely — is something many home users and small businesses overlook until something goes wrong. Excel gives you several layers of protection, and they work very differently from each other. This guide explains each level clearly so you can choose the right one for your situation.

The Three Levels of Excel Protection

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

• Sheet protection — prevents editing of cells in a specific worksheet. The file can still be opened by anyone.
• Workbook structure protection — prevents sheets being added, deleted, renamed or moved. It does not lock cell contents.
• File-open password (encryption) — the file cannot be opened at all without the correct password. This is the strongest protection.

These can be used independently or combined. Most people only need sheet protection for everyday use. If you are sharing sensitive data, you should use a file-open password as well.

How to Protect a Worksheet

Sheet protection locks the cells in a worksheet so nobody can edit them without a password. Here is how to set it up:

1. Click on the sheet tab you want to protect at the bottom of the screen.
2. Go to the Review tab on the ribbon.
3. Click Protect Sheet.
4. A dialog box appears. Enter a password if you want one (it is optional — you can protect without a password, though this only stops accidental edits).
5. Tick or untick the boxes depending on what you want users to still be able to do.
6. Click OK and confirm the password if you set one.

What Can Users Still Do on a Protected Sheet?

The protection dialog gives you fine-grained control. By default, users can select cells but nothing else. You can choose to also allow:

• Select locked cells — ticked by default, lets people click around
• Select unlocked cells — useful for data entry areas
• Format cells, columns, rows — lets people change appearance without editing data
• Insert/delete rows or columns — allow if people need to add data
• Sort and use AutoFilter — useful for read-only data people may want to filter
• Use PivotTable and PivotChart

Think about your use case before ticking anything. For a payroll sheet you share for review, you probably want to allow nothing beyond selecting cells.

Unlocking Specific Cells Before You Protect

By default, every cell in Excel is marked as “locked” — but this only takes effect once you turn on sheet protection. If you want some cells to remain editable (for example, a data entry column) while protecting the rest, you need to unlock those cells first:

1. Select the cells you want people to be able to edit.
2. Right-click and choose Format Cells, or press Ctrl+1.
3. Go to the Protection tab.
4. Untick Locked.
5. Click OK.
6. Now go to Review > Protect Sheet as normal.

Those unlocked cells will remain editable after protection is applied. Everything else will be locked. This is ideal for invoice templates or forms where you want users to fill in certain fields but not touch the formulas.

How to Protect the Workbook Structure

Workbook structure protection is separate from sheet protection. It stops users from:

• Adding or deleting sheets
• Renaming sheets
• Moving or copying sheets
• Hiding or unhiding sheets

To apply it, go to Review > Protect Workbook. Enter a password and click OK. This is useful when you have a workbook with a specific structure — such as a template with a fixed set of sheets — and you do not want anyone to change the layout.

Note: workbook structure protection does not prevent editing cell contents. You need to combine it with sheet protection if you want both.

Adding a File-Open Password (Encryption)

If the file contains sensitive information and you do not want it opened without a password, you need to encrypt it. This is the only protection that prevents someone from opening the file at all:

1. Go to File > Info.
2. Click Protect Workbook.
3. Select Encrypt with Password.
4. Enter a strong password and click OK.
5. Re-enter the password to confirm.
6. Save the file.

From now on, anyone who tries to open this file will be prompted to enter the password. Without it, the file is unreadable.

Removing Protection

To remove sheet protection, go to Review > Unprotect Sheet and enter the password. To remove workbook structure protection, go to Review > Protect Workbook again and enter the password. To remove a file-open password, go to File > Info > Protect Workbook > Encrypt with Password, delete the password from the field and click OK, then save.

Important Warning About Passwords

Excel’s sheet and workbook structure protection can be bypassed with third-party tools — it is not strong encryption. It is good enough to prevent casual edits but should not be relied on to protect genuinely sensitive data. The file-open encryption (Encrypt with Password) is much stronger and uses AES-256 in modern versions of Excel.

The most important warning: if you forget an Excel password, there is no official recovery method. Microsoft cannot retrieve it. Sheet-level passwords can sometimes be recovered with third-party software, but file-open passwords on modern Excel files are effectively unrecoverable. Write your passwords down and store them somewhere safe — a password manager is the right tool for this.

Quick Summary