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.