To stop anyone deleting, hiding, renaming, adding or moving tabs in an Excel file, choose Review > Protect Workbook and tick Structure. This is separate from protecting a sheet, which stops cell edits, and from a file password, which stops the file being opened. Each blocks a different thing, so pick the one that matches your worry.
What are the three kinds of protection?
| Type | Where to find it | What it blocks | What it leaves open |
|---|---|---|---|
| Workbook structure | Review > Protect Workbook | Adding, deleting, renaming, hiding, unhiding and moving sheets | Typing in cells on any sheet |
| Sheet protection | Review > Protect Sheet | Changing locked cells on that sheet, depending on the options you tick | Deleting the sheet itself; changes on other sheets |
| File password | File > Info > Protect Workbook > Encrypt with Password | Opening the file without the password | Everything, once the file is open |
Most people reach for sheet protection first and then find that someone deleted a whole tab anyway. Sheet protection does not guard the tab itself.
How do I protect the workbook structure?
- Open the file in desktop Excel and set up your tabs the way you want them.
- Go to Review > Protect Workbook. The button is sometimes labelled as protecting the structure of the workbook.
- In the box, tick Structure. Leave Windows unticked unless your version offers it and you need it.
- Add a password if you like, and confirm it. Without a password, anyone can turn protection off with a click, so it only guards against accidents.
- Press OK, then right-click a tab. Options like Delete, Rename, Insert, Hide and Move should now be greyed out.
Which tabs does it help with?
It earns its keep in a household budget file with a fixed layout. Say your workbook has Entries, Summary, Categories and Notes. Formulas on Summary refer to Categories. If a family member deletes Categories by mistake, the Summary shows #REF! errors everywhere. With structure protection, the tab cannot be deleted, so the formulas keep working.
Can people still change data?
Yes. Workbook structure protection says nothing about cells. A person can still type over formulas on an unprotected sheet. To guard the formulas, protect each sheet too, and open an entry area with Allow Edit Ranges so family can still type. The order you do it in does not matter, but test everything after you finish.
- Structure protection: tab deletion, hiding, renaming, moving.
- Sheet protection: cell contents and formatting.
- Allow Edit Ranges: the exception cells within a protected sheet.
- File password: whether the file opens at all.
How do hidden sheets fit in?
Hiding a sheet is not protection. A hidden sheet can be unhidden with two clicks, unless structure protection is on, in which case the Hide and Unhide choices are blocked. So the pair works as a light privacy measure: hide the sheet, protect the structure, and set a password. It remains a deterrent, not a lock. Anyone who can open the file with the right access can find ways to read it, so keep truly sensitive details out of the shared file.
What can still go wrong?
| Situation | Why it happens | What to do |
|---|---|---|
| You cannot add a tab either | Structure protection blocks adding as well | Unprotect, add the tab, protect again |
| Someone saves a copy and edits that | Protection does not stop copies | Share a copy only with people you trust |
| The password is lost | No easy recovery for a file password | Keep a backup copy of the file saved without that password |
| Excel for the web behaves differently | Some protection settings are not available there | Set up and change protection in the desktop app |
A final check
- Right-click a tab and confirm Delete and Rename are greyed out.
- Try typing in a locked formula cell; it should be refused.
- Open the file on another device and confirm everything still looks the same.
- Save a copy before you protect, so you can start again if you hit a problem.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


