No Ticket Needed

Appearance

How to Protect a Sheet or Workbook in Excel

Applies toMicrosoft 365ExcelExcel for the web
5 min fix Updated 9 Aug 2026

By , 10+ years in IT support and helpdesk How these guides are checked

Quick Answer

Go to the Review tab, click Protect Sheet, choose a password (optional), check the boxes for actions you want to allow users to do, and click OK.

Checked against Microsoft 365 Roadmap, Microsoft Learn - end of support and retirement and between 5 Aug 2026 and 12 Sep 2026. Nothing published in that period has been linked to this guide.

Summary ​

Excel lets you lock cells, protect a sheet, and protect the workbook structure to stop accidental edits. No admin rights are needed — these are user-level protections built into Excel. This article covers applying each one, taking it off again, and the case nobody wants: a protection password nobody has.

Excel has three separate protections, and choosing the wrong one is the usual reason a spreadsheet is not behaving the way you expected:

  • Sheet protection (Review > Protect Sheet) stops people typing over cells and formulas on one sheet. Anyone can still open the file and read everything in it.
  • Workbook structure protection (Review > Protect Workbook) stops people adding, deleting, hiding, renaming, or reordering the sheet tabs. It leaves the cells fully editable.
  • File encryption (File > Info > Protect Workbook > Encrypt with Password) is a different thing entirely — without the password the file does not open at all. That one is covered in How to Password-Protect a PDF or Word Document.

Use one, two, or all three. They stack, and each has its own password.

Before You Start ​

  • Microsoft Excel (desktop or web).
  • If you are setting a password, somewhere to store it. There is no recovery route if it goes missing — section 5 explains what is left when it does.

Instructions ​

1. Protect a Worksheet ​

Prevent other users from editing cells on a specific sheet.

  1. Open the worksheet you want to protect.
  2. Go to the Review tab.
  3. Click Protect Sheet.
  4. Optionally enter a password (leave blank for protection without a password).
  5. Choose what users are allowed to do on the protected sheet:
    • Select locked cells — users can click on locked cells (but not edit them).
    • Select unlocked cells — users can click and edit unlocked cells.
    • Format cells, Insert rows, Delete rows, etc. — check the actions you want to permit.
  6. Click OK. If you set a password, re-enter it to confirm.

2. Unlock Specific Cells Before Protecting ​

Allow editing of certain cells (e.g., input fields) while locking the rest.

  1. Select the cells you want to remain editable.
  2. Press Ctrl + 1 to open Format Cells.
  3. Go to the Protection tab.
  4. Uncheck Locked.
  5. Click OK.
  6. Now protect the sheet (Step 1 above). Only the unlocked cells can be edited.

3. Protect an Entire Workbook Structure ​

Prevent users from adding, deleting, renaming, or reordering sheets.

  1. Go to the Review tab.
  2. Click Protect Workbook.
  3. Check Structure (prevents sheet changes).
  4. Optionally enter a password.
  5. Click OK.

4. Unprotect a Sheet or Workbook ​

Removing protection you applied yourself takes seconds from the same Review tab.

Sheet:

  1. Open the sheet and go to the Review tab. The button that reads Protect Sheet on an unprotected sheet reads Unprotect Sheet when protection is on — that label is how you confirm which state you are in.
  2. Click Unprotect Sheet.
  3. If a password was set, type it in the dialog and click OK. If no password was set, protection lifts straight away with no prompt.
  4. The cells accept typing again and the button reads Protect Sheet once more. Nothing in the sheet has changed — protection is a switch, not an edit, so you can turn it back on at any point and your locked and unlocked cells are exactly as you left them.

Workbook structure:

  1. Go to the Review tab and look at the Protect Workbook icon. If it is highlighted, the structure is protected.
  2. Click Protect Workbook. The same button does both jobs, so clicking it while protection is on removes it.
  3. Enter the password if one was set, and click OK. Sheet tabs can now be added, deleted, hidden, renamed, and reordered again.

Note: These are two independent switches. Unprotecting the sheet does not unlock the sheet tabs, and unprotecting the structure does not make a locked cell editable. If one thing still refuses to budge, it is the other protection you have hit.

5. If You Have Lost the Protection Password ​

A protection password nobody has cannot be recovered, so the routes forward are practical rather than technical.

Microsoft is direct about this: if you forget the password, Microsoft cannot retrieve it, and Excel cannot recover it for you. There is no reset link and no support case that unlocks it. Your IT department cannot lift it either — they administer accounts and machines, not the contents of a file someone locked. And we will not point you at password-removal tools: running an unknown program against a company file creates a second problem on top of the first.

Here is what does work, in the order worth trying:

  1. Work out which protection you have actually hit. Cells that refuse typing are sheet protection. Sheet tabs that cannot be renamed or deleted are workbook structure protection. A file that will not open at all is file encryption, which is a separate password and a separate problem. Each has its own password, so the one you remember may open a different lock than the one blocking you.
  2. Go back to whoever set it. This is the fix in most offices, and it is faster than any workaround. If the file lives in OneDrive or SharePoint, the version history panel names the person who saved each version, which tells you who to ask even when the file has been passed around. Send them the file path and the exact name on the sheet tab.
  3. Look for a version saved before protection went on. Open the file from OneDrive or SharePoint and check its version history — a copy from before the password was applied opens with no password at all. Download that version rather than restoring it, so the current file is left alone until you are sure. See How to Restore a Previous Version of a File in OneDrive.
  4. Copy the contents into a fresh workbook. Sheet protection allows selecting locked cells unless whoever applied it cleared that box, so in most cases you can click the Select All corner box where the row and column headers meet, press Ctrl + C, open a new workbook, and paste. Values, formulas, and formatting come across, and the new file carries no protection at all. Charts, buttons, and form controls frequently do not survive the trip, so check the result before you rely on it.
  5. Rebuild from the source. If selection is blocked too, the data came from somewhere — an export, a report, a colleague's copy. Rebuilding from that source is slower than everything above, and still faster than the alternative, which does not exist.

If the workbook is something the business runs on and none of the above reaches it, the ticket is about the file, not the password. Send IT this, with your own file path and date in place of the example: "I cannot edit the workbook at Finance/Budget 2026.xlsx on the Finance SharePoint site. The sheet is protected with a password nobody on the team has. Please tell me who owns this file, or restore a copy from backup dated before 1 June 2026."

Troubleshooting ​

DANGER

Sheet protection is not a security feature — it prevents accidental edits but can be bypassed by determined users. Do not rely on it to protect sensitive or confidential data.

Symptom / ErrorPotential CauseSolution
Cannot type in a cell; error says "protected"The sheet is protectedGo to Review > Unprotect Sheet (step 4). If the password is not yours, ask the sheet's owner, or check whether there is an unlocked cell you are meant to be typing in instead.
Forgot the sheet protection passwordPassword was set and lostThere is no recovery route — Microsoft cannot retrieve it. Work through step 5: ask the person who set it, open a version of the file saved before protection went on, or copy the contents into a fresh workbook.
Cannot add or delete sheetsWorkbook structure is protectedGo to Review > Protect Workbook and enter the password to unprotect. The same button toggles it back on.
Unprotect Sheet worked but the tabs are still lockedTwo separate protections are onSheet protection and structure protection are independent switches. Turn off the second one at Review > Protect Workbook (step 4).
Anyone can still open and read the fileProtection is not encryptionProtect Sheet stops edits, not reading. To stop the file opening at all, use File > Info > Protect Workbook > Encrypt with Password.

Last updated:

Frequently asked questions

What is the difference between Protect Sheet and Protect Workbook?
Protect Sheet stops users from typing over data or changing formulas on that specific page. Protect Workbook stops users from adding, deleting, hiding, or renaming the sheets themselves.
What happens if I forget the protection password?
Microsoft cannot retrieve it and Excel cannot recover it for you. There is no reset process, and your IT department cannot lift it either. Go back to whoever protected the sheet, restore a version of the file saved before protection was applied, or rebuild the sheet from the source data. Store the password in a password manager the moment you set the next one.
Is Protect Sheet the same as putting a password on the Excel file?
No. Protect Sheet stops edits, but anyone can open the workbook and read every cell. To stop the file opening at all, use File then Info then Protect Workbook then Encrypt with Password, which encrypts the file itself.