How To Unhide Tabs In Google Sheets

In this tutorial, you will learn how to unhide tabs in Google Sheets.

Hiding tabs in Google Sheets can be useful to keep your spreadsheet easy to navigate and hide unnecessary calculations or other information. It’s quick and easy to hide a tab you don’t currently need by right clicking on the tab and choosing Hide Sheet from the menu, but what when you want to unhide those tabs? You can’t right-click on a hidden tab, so how do you find them to unhide them? Fortunately, it’s not hard to unhide hidden tabs in Google Sheets. Just follow these steps

Step 1

Open the View menu and hover over the Hidden Sheets submenu

Step 2

A list of the hidden sheets (or tabs) in your Google Sheet will appear. Click on the one you want to unhide

Step 3

The tab will reappear in the tab list at the bottom of the screen

Quick Navigation


Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to unhide tabs in Google Sheets. Want more? Check out all the Google Sheets Tutorials.

Get more Google Sheets stuff

Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.