ysskrishna logoysskrishna

Chapter 3 of 6 · 4 min

Hide and unhide tabs in bulk

Use hiding for shared views and audits; unhide everything in one step when you need to edit.

Hiding is the gentle alternative to deleting. A hidden tab keeps its data and formulas, but it disappears from the tab strip. That makes a shared workbook easier to read without losing the sheets that power it.

Hide many tabs

  1. Open the sidebar. Tick the tabs to hide: raw data, lookups, calculations.
  2. Click Hide.
  3. They vanish from the tab strip and show a HIDDEN badge in the sidebar list.

Unhide many tabs

  1. Search or scan for tabs with the HIDDEN badge.
  2. Tick them.
  3. Click Unhide.

Unhiding in bulk is where the sidebar saves the most time: in plain Sheets, you unhide hidden tabs from the View → Hidden sheets menu or the All sheets list, one by one.

What hiding is, and is not

Hiding doesHiding does not
Remove the tab from the tab stripProtect the data
Keep formulas that reference it workingStop editors from unhiding it
Tidy the view for readersLeave it out of an Excel (.xlsx) download, which includes hidden sheets

Anyone with edit access can unhide a tab. If data must not be seen, put it in a separate file with different sharing, or use protected ranges for edits (Data → Protect sheets and ranges), which control editing, not viewing.

An audit routine

Before sharing or handing over a workbook:

  1. Unhide everything (select all HIDDEN tabs → Unhide).
  2. Review each tab: keep, delete, or hide again.
  3. Hide the working tabs you keep.
  4. Leave one clear first tab (a summary or README) visible and active.

Step by step: tidy a shared report

  1. In a workbook with tabs Summary, Raw_Jan, Raw_Feb, Lookups, search Raw.
  2. Tick both raw tabs and Lookups. Click Hide.
  3. Check the tab strip now shows only Summary, and the sidebar shows three HIDDEN badges.
  4. Reverse it: tick the three, click Unhide.

Practice: hide the archive, keep the current quarter

Suppose a file has these tabs:

TabShould readers see it?
DashboardYes
Q4 2026Yes
Q3 2026, Q2 2026, Q1 2026No (archive)
ListsNo (lookup data)
  1. In the sidebar, search 2026. Untick Q4 2026, tick the other three quarters.
  2. Click Hide. The three tabs now show the HIDDEN badge in the list.
  3. Clear the search, tick Lists, click Hide again.
  4. Look at the tab bar at the bottom of the sheet: only Dashboard and Q4 2026 remain.

Next quarter, search 2026 again, tick Q4 2026 and hide it, and the new quarter becomes the visible one.

Hidden is not private

This is the most important point in the chapter. Anyone with edit access can unhide a tab from View → Hidden sheets or the right-click menu. Anyone with view access can still see hidden data in some routes, for example a downloaded copy of the file, and formulas on visible tabs keep reading hidden tabs normally. If a tab holds salaries, personal data or anything the readers must not see, move it to a separate file with its own sharing settings. Protected ranges (Data → Protect sheets and ranges) stop edits, not viewing.

Hiding versus deleting

ChooseWhen
HideYou still need the data, or formulas read it, and you only want a tidy tab bar
DeleteNothing reads the tab and the data exists elsewhere (or in version history)
Move to another fileThe data is sensitive, or the file is slow because of its size

A useful rule of thumb: hide by default, delete only what you would not miss, and move anything private.

Common mistakes

  • Hiding the only visible tab. Sheets needs at least one visible tab, so leave one unticked.
  • Forgetting hidden tabs when you hand the file over. Mention them in a README tab so the next owner knows they exist.

Quick check

  1. Do formulas in Summary still work after you hide Raw_Jan?Yes. Hidden tabs keep working.

  2. Is hiding a way to keep salaries private from editors?No. Editors can unhide tabs. Use a separate file with separate sharing.

  3. What is step 1 of the hand-over audit?Unhide everything so nothing is reviewed by accident.

Continue exploring

ProductGoogle WorkspaceGoogle Sheets Tab Manager

Google Sheets Tab Manager

Your workbook outgrew the tab bar. Clean it up in batches.
Google Sheets Tab Manager
Google Workspace Add-ons
Google Sheets
Google Apps Script
BlogCover image for How to Delete Multiple Tabs in Google Sheets at Once (Bulk Hide, Rename, Sort)

How to Delete Multiple Tabs in Google Sheets at Once (Bulk Hide, Rename, Sort)

Google Sheets Tab Manager
Google Workspace Add-ons
+1
2 min read
ProductGoogle WorkspaceGoogle Sheets Merge Tools

Google Sheets Merge Tools

Repeatable merges in Google Sheets, without the misclick marathon.
Google Sheets Merge Tools
Google Workspace Add-ons
Google Sheets
Google Apps Script
CourseCover image for Table Converter for Google Sheets: Import and Export Markdown, JSON, HTML and CSV

Table Converter for Google Sheets: Import and Export Markdown, JSON, HTML and CSV

Import Markdown, JSON, HTML and CSV tables into Google Sheets without broken columns, and export any range as clean Markdown, JSON, HTML or CSV.

Google Sheets Table Converter
Google Sheets
+1

6 chapters · 16 min

ProductGoogle WorkspaceGoogle Sheets Text Power Tools

Google Sheets Text Power Tools

Fix messy sheet text in place. Case, trim, strip, and extract without leaving the grid.
Google Sheets Text Power Tools
Text & Data Conversion
Google Workspace Add-ons
Google Sheets
ProductGoogle WorkspaceGoogle Sheets Table Converter

Google Sheets Table Converter

Pipe tables, JSON, CSV, or HTML in and out of Sheets, without leaving the grid you are already in.
Google Sheets Table Converter
Markdown & Docs
Text & Data Conversion
Google Workspace Add-ons