How to unhide all sheets in Google Sheets at once
By Jake Marsh · Updated
Google Sheets has no "unhide all" command: hidden tabs come back one at a time from View, Hidden sheets. To unhide all sheets at once, open Extensions, Tabherd, Open Tabherd, click Hidden to tick every hidden tab, choose Show (unhide), click Preview, then Apply. Every hidden tab is visible again, and Undo in History hides them back.
Steps
- Open Tabherd from the Extensions menu. The sidebar lists every tab, hidden ones included.
- Click Hidden. Every hidden tab is ticked.
- Untick any you want to keep hidden, or type in the search box to narrow the list, such as
2025, and tick those. - Choose Show (unhide).
- Click Preview. It lists each tab that will be shown.
- Click Apply.
Hide them again when you're done
Tabs are often unhidden to check something and then forgotten. Open History in the sidebar and click Undo next to the change, or choose Undo the last change from the Tabherd menu. The same tabs are hidden again. If someone has hidden or deleted one of them in the meantime, Tabherd leaves it alone and tells you.
Hide many tabs, then find them
Hiding works the same way: tick the tabs, choose Hide, Preview, Apply. Tabherd won't hide every tab, since Google Sheets needs at least one visible. To see what's hidden at any time, click Hidden in the list. To keep a spreadsheet with many tabs easy to get around without hiding anything, a Table of contents tab puts a link to every tab on the first tab.
Who can see hidden tabs
Hiding a tab is a way to tidy the tab bar, not to keep data private. Anyone who can edit the file can unhide it, and a downloaded copy of the spreadsheet includes it. To give people only part of a spreadsheet, the data has to go into a separate file; Rowsplit splits a sheet into files and shares each one with the right people.
What it costs
Tabherd is $2.99 a month or $19 a year per Google account. Free trial: 30 days or 60 applied changes, whichever comes first. No card needed. Every plan and the install link are on the Tabherd page.
Tabherd: Bulk Tab Manager for Sheets
Hide, sort, rename, protect and copy many Google Sheets tabs at once, with a preview and undo for every change $2.99 a month or $19 a year per Google account.
Questions
Can I unhide only tabs whose names match something?
Yes. Type part of the name in the search box, tick the matching tabs, and choose Show (unhide). Hidden tabs that don't match stay hidden.
Is there a keyboard shortcut to unhide every tab in Google Sheets?
No. Google Sheets has no shortcut or menu item that unhides all tabs at once.
Why can't I unhide a tab?
If you only have view or comment access to the file, you can't change which tabs are hidden. Ask the owner for edit access.
Does unhiding use up my trial?
Each Apply counts as one change, however many tabs it shows. Preview and Undo are free.
More Tabherd guides
- How to make a copy of a template tab for each name in a list
- How to sort tabs alphabetically in Google Sheets
More Google guides
- How to compare two Google Sheets for differences (Tabmeld)
- How to email each person only their rows from a Google Sheet (Scheduled Sheet Reports)
- How to move GA4 Reports Builder reports to Trafficledger (Trafficledger)
- How to show dotted-line reporting on an org chart from Google Sheets (Rowtree)