Spreadsheets

Protect workbook structure so nobody deletes or hides your tabs

Protect workbook structure in Excel so nobody deletes, hides or renames your tabs, and see how it differs from sheet protection and a file password.

Editorial illustration for Protect workbook structure so nobody deletes or hides your tabs

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?

TypeWhere to find itWhat it blocksWhat it leaves open
Workbook structureReview > Protect WorkbookAdding, deleting, renaming, hiding, unhiding and moving sheetsTyping in cells on any sheet
Sheet protectionReview > Protect SheetChanging locked cells on that sheet, depending on the options you tickDeleting the sheet itself; changes on other sheets
File passwordFile > Info > Protect Workbook > Encrypt with PasswordOpening the file without the passwordEverything, 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?

  1. Open the file in desktop Excel and set up your tabs the way you want them.
  2. Go to Review > Protect Workbook. The button is sometimes labelled as protecting the structure of the workbook.
  3. In the box, tick Structure. Leave Windows unticked unless your version offers it and you need it.
  4. 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.
  5. 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?

SituationWhy it happensWhat to do
You cannot add a tab eitherStructure protection blocks adding as wellUnprotect, add the tab, protect again
Someone saves a copy and edits thatProtection does not stop copiesShare a copy only with people you trust
The password is lostNo easy recovery for a file passwordKeep a backup copy of the file saved without that password
Excel for the web behaves differentlySome protection settings are not available thereSet up and change protection in the desktop app

A final check

  1. Right-click a tab and confirm Delete and Rename are greyed out.
  2. Try typing in a locked formula cell; it should be refused.
  3. Open the file on another device and confirm everything still looks the same.
  4. Save a copy before you protect, so you can start again if you hit a problem.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports