Show Hidden Sheets in Google Sheets (Easiest Way in 2024)

In this tutorial, we will show you exactly how to show hidden sheets on Google Sheets in just a few steps. Simply follow the steps below.

‍

Showing Hidden Sheets on Google Sheets

Follow the process below to make hidden sheets visible on Google Sheets.

1. Look for Missing Sheets in the Bottom Tab Row

Open your Google Sheets document and check the bottom row where all your sheet tabs are listed. If a sheet is missing from this row, it may be hidden.

‍

2. Open the View Tab to Find Hidden Sheets

Go to the top menu bar and click on the “View” tab. This will open a drop-down menu with various viewing options, including hidden sheets.

‍

3. Select the Hidden Sheet From the List

In the “View” menu, click the "Hidden Sheets" section. If any sheets are hidden, they will appear here.

‍

‍

Click on the hidden sheet you want to show; in this case, we'll select "Show Sheet2" and it will reappear in the bottom tab row.

‍

4. Verify That the Sheet Is Now Visible

Check the bottom row of sheet tabs again. The hidden sheet you selected should now appear alongside the other visible sheets. Repeat steps 2–3 to show other hidden sheets.

‍

‍

We hope that you now have a better understanding of showing hidden sheets on Google Sheets. If you enjoyed this article, you might want to check out our articles on how to combine multiple sheets into one and how to search all tabs in Google Sheets.