How To View Hidden Sheets In Google Sheets

Google Sheets is an incredibly versatile tool, offering a myriad of functionalities to help with data organization and analysis. One such feature is the ability to create and hide sheets. This can be particularly useful when you want to keep data out of sight, but not necessarily delete it. But what happens when you need to view these hidden sheets? In this post, we’ll guide you through the simple process of revealing hidden sheets in Google Sheets.

Steps to View Hidden Sheets

Step 1: Open Your Google Sheets Document

The first thing you’ll need to do is open the Google Sheets document that contains the hidden sheet(s) you want to view. Simply navigate to Google Sheets, find your document, and open it.

Step 2: Locate the Sheets Bar

At the bottom of your Google Sheets workspace, you’ll see a bar that contains the names of all your visible sheets. This is referred to as the Sheets Bar.

Step 3: Access the Context Menu

To reveal a hidden sheet, you’ll need to access the context menu. This can be done by right-clicking anywhere on the Sheets Bar.

Step 4: View Hidden Sheets

Upon right-clicking, a menu will appear. Select the View All Sheets option. This will bring up a list of all your sheets, both visible and hidden. The hidden sheets will be distinguished by a different icon. To view a hidden sheet, simply click on it. This will make it visible and active.


And there you have it! You can now easily view hidden sheets in Google Sheets. Remember that if you no longer need a sheet to be hidden, you can always make it visible again using the same context menu. Just right-click on the sheet’s name and select Show Sheet.

Reference Commands

// To access the context menu
Right-click on the Sheets Bar

// To view all sheets
Select "View All Sheets" from the menu

// To view a specific hidden sheet
Click on the name of the hidden sheet

// To make a hidden sheet visible
Right-click on the sheet's name -> Select "Show Sheet"