How to Hide and Unhide Worksheets in Google Sheets

When managing complex workbooks in Google Sheets, having dozens of visible sheet tabs along the bottom bar can quickly clutter your workspace. Whether you are maintaining background calculation tables, holding raw reference data, preparing monthly reports before client review, or simply decluttering your layout, hiding specific worksheets keeps your interface organised and legible.

Hiding a sheet removes its tab from the bottom panel while preserving all its formulas, cell links, and references across other active sheets in your workbook. This guide demonstrates how to hide individual sheets, reveal hidden sheets, and understand how sheet visibility interacts with collaborator permissions.

How to Hide a Sheet in Google Sheets

Hiding an individual tab in your workbook is simple and can be completed in just two clicks:

1. Open your spreadsheet in Google Sheets on your web browser.
2. Locate the sheet tab you wish to hide along the bottom bar of your browser window.
3. Right-click the sheet tab, or click the small downward arrow next to the sheet name.
4. From the pop-up context menu, click Hide sheet.
5. The sheet tab will vanish immediately from the bottom bar.

Note: A workbook must contain at least one visible worksheet. Google Sheets will not allow you to hide every sheet in a spreadsheet document.

How to View and Unhide Hidden Sheets

Whenever you need to review, update, or unhide an obscured worksheet, you can access it through the main application menu or the all-sheets selector:

Method 1: Using the View Menu

1. In the top menu bar, click View.
2. Hover over or click Hidden sheets.
3. A sub-menu will display every worksheet currently hidden in the active workbook.
4. Click the name of the sheet you want to reveal. The worksheet will reappear along your bottom tab bar and open immediately.

Method 2: Using the All Sheets Hamburger Icon

1. In the bottom-left corner of the Google Sheets window (to the left of the + Add Sheet button), click the All sheets icon (represented by four horizontal lines).
2. In the pop-up list, hidden worksheets appear with slightly dimmed or greyed-out titles.
3. Click the hidden sheet’s name to restore it to the tab bar instantly.

How Formulas and Cell References Behave in Hidden Sheets

Hiding a sheet in Google Sheets does not suspend calculations or break data dependencies. Any formula in a visible worksheet referencing cells in a hidden sheet (for example, =SUM('Raw Data'!B2:B100) or =VLOOKUP(A2, 'Rates'!A:C, 2, FALSE)) continues to recalculate accurately in real time.

Important Note on Security and Hidden Sheets

Hiding a sheet is a visual organisation tool rather than a confidentiality or security mechanism. Any user with edit or view access to your spreadsheet can easily unhide hidden sheets by clicking View > Hidden sheets. If you need to restrict sensitive figures from certain collaborators, consider using Data > Protect sheets and ranges to restrict editing rights, or maintain private datasets in a separate secured spreadsheet and pull approved summaries into the public sheet using the IMPORTRANGE function.