How to Secure Excel Sheet with Password

If you want to keep people from seeing your data, protect the file so it asks for a password when they open it. If you want to keep people from changing your data, use Excel’s sheet/workbook protection so they can’t edit. Same “password” goal, very different buttons.

Here’s a quick decision tree before you start:

• Goal: protect access (view/open)
• Use Encrypt with Password (workbook-level).
• Goal: protect against editing (no changes)
• Use Protect Workbook or Protect Sheet (editing protection).

Once you know which one you need, the steps are straightforward.

Choose what you’re protecting: viewing (open) vs editing

People often say “lock it with a password,” but Excel has two common meanings:

Protecting so others must enter a password to open

This is what you want for “password protect an Excel File” scenarios. You don’t want anyone opening the workbook unless they know the password. In Excel, that’s done with the workbook encryption flow.

Protecting so others can open but can’t edit

This is what you want for “protect an Excel sheet with password” in the editing sense. People can view your content, but they can’t change cells unless you allow it.

If you pick the wrong one, it can feel like Excel “isn’t working,” even when the feature is doing exactly what you told it to do.

Password-protect the whole workbook (Encrypt with Password)

This path is for the outcome: protect Excel file with password to open.

1. Open your Excel workbook.
2. Go to File > Info.
3. Find Protect Workbook and select the option Encrypt with Password.
4. Enter your password in the Password box.
5. Select OK.

That’s it. The workbook is treated as password-protected for opening, which is the “viewing lock” most people mean when they say “password protect.”

Password-protect a specific sheet (Protect Sheet from editing)

This path is for the outcome: lock an Excel sheet with a password (in the sense of preventing edits).

Use this when you want to secure one worksheet inside a workbook, not necessarily the entire file.

1. Open the workbook that contains the sheet.
2. Go to the Review tab.
3. Click Protect Workbook or choose Protect Sheet depending on what you’re protecting.

• Use Protect Sheet when you want that specific sheet locked from editing.
• Use Protect Workbook when you want the whole workbook behavior protected.

In Excel, editing protection is controlled from the Review tab using either Protect Workbook or Protect Sheet.

Restrict access to a sheet in Excel: what to lock and what to leave editable

When you’re trying to restrict access to a sheet in Excel, you’re really choosing which protection you want:

If you want to stop editing

• Choose Review tab > Protect Sheet (for one sheet) or Review tab > Protect Workbook (for the whole file).
• This is the “protect an Excel sheet with password” route for preventing changes.

If you want to stop viewing altogether

• Choose File > Info > Protect Workbook > Encrypt with Password.
• This is the “password protect an Excel File” route for keeping people out of the file.

A simple way to decide what to lock:

• If you have a workbook with a sensitive summary but other tabs are fine, protecting the sheet is often the cleanest choice.
• If the whole workbook contains private info, encrypting the workbook may fit better.

Also, think about how your teammates or clients will use the file:

• If they only need to read it, encrypting for open-lock is a strong fit.
• If they need to work with it but you only want them to change specific cells, sheet/workbook protection is the way to control what’s editable.

Protect Excel sheet with password online vs in Excel (what to expect)

You’ll see two different “places” people try to protect files:

Protect in Excel (desktop)

The classic Excel flow looks like this:

• File > Info > Protect Workbook > Encrypt with Password for opening/view protection.
• Review tab > Protect Workbook/Protect Sheet for edit protection.

Protect “online”

When you protect in an online version of Excel (or a browser-based flow), the options you see can change depending on the exact app and file type. So the outcome you want might be there, but it may appear under different menus, or you might only see some of the protection options.

If you’re trying to do protect Excel sheet with password online, decide which bucket matches your goal:

• Do you want a password at open (view protection)?
• Or do you want to block editing (editing protection)?

If you’re missing the exact option you expected, it usually means you’re looking for the wrong protection type, or you’re in the wrong flow (open vs edit).

Common issues: Why can't I password protect an Excel File?

This comes up a lot: “Why can’t I password protect an Excel File?”

One common reason is that Excel offers different protection features depending on what you’re trying to secure:

• If you’re trying to stop editing but you only look for “password to open,” you may not get the result you expect.
• If you’re trying to password-protect access, but you only use Protect Sheet (editing protection), the file can still open without asking for a password.

So before you assume something is broken, check what flow you’re in:

• For open/view protection, use:
• File > Info > Protect Workbook > Encrypt with Password
• For edit protection, use:
• Review tab > Protect Workbook or Review tab > Protect Sheet

If you’re in the right area but the option still doesn’t appear, it usually means the protection feature you’re trying to use doesn’t match your goal (open vs edit). That’s why it can feel confusing—Excel uses similar words for different protections.

How to remove password protect an Excel file (what to do instead)

If a workbook is encrypted with a password to open, you can’t “remove” that password while keeping the workbook locked. You need access to the workbook first.

Here are the options people typically use:

• If you still know the password
• Open the workbook normally.
• Then go back to the same protection area and turn off the protection (or re-save it without protection).
• If you don’t know the password
• Don’t guess. Without the right password, the encrypted/open-protect feature is meant to keep the workbook inaccessible.

For edit protection (sheet/workbook protection), removal is simpler once you can open the workbook. You switch off the protection in the Review area instead of trying to “remove” encryption that you didn’t set.

If your goal is “remove password protection,” make sure you know which type you used:

• Encrypt with Password (password to open/view) is different from
• Protect Sheet/Protect Workbook (protection/lock for editing)

Quick checklist before you share the file

Before you send your workbook to someone, do a quick sanity check so you don’t run into the “oops, they can edit” problem.

• Decide which protection you used:
• Encrypt with Password (protects the workbook from opening without the password)
• Protect Workbook/Protect Sheet (protects the workbook/sheet from editing)
• Re-check the exact Excel paths you used:
• File > Info > Protect Workbook > Encrypt with Password (open/view)
• Review tab > Protect Workbook / Protect Sheet (edit)
• Test it yourself:
• Open the file the same way your recipient would.
• Confirm they get the right behavior (a password prompt for open, or edit blocked for protection).
• If you protected a specific sheet:
• Open the workbook and test whether the other sheets behave the way you intended.

After you protect your file, double-check the protection type (open/view vs edit) and test it before sharing.