How to Unhide a Worksheet in Google Sheets

Hiding worksheets in a spreadsheet application like Microsoft Excel or Google Sheets is an effective may to make it difficult for someone to edit data, but still keep that data available in case you need it later, or in case it needs to be used by a formula.

But you might find that you need to edit some of the data in a hidden worksheet, which can be difficult in Google Sheets if you are having trouble unhiding the sheet in question. Our tutorial below will show you a couple different methods that can help you to unhide a worksheet.

 

How to Unhide a Tab in Google Sheets

The steps in this article were performed in Google Chrome, but will also work in desktop Web browsers like Firefox or Edge. This guide assumes that you have an existing workbook in Google Sheets, and that this workbook contains at least one hidden sheet.

Step 1: Open your Google Drive at https://drive.google.com/drive/my-drive and select the file containing the worksheet that you want to unhide.

 

Step 2: Click the All sheets button at the bottom-left of the window.

open the all sheets menu in google sheets

Step 3: Click the hidden worksheet that you want to unhide. The hidden sheets are a slightly lighter gray color than the visible ones.

how to unhide sheets in google sheets

 

 

You can also unhide a sheet by clicking the View tab at the top of the window, selecting the Hidden sheets option, then clicking on the sheet that you wish to unhide.

unhide tabs in google sheets

 

 

Did you create a spreadsheet in Google Sheets, only to discover later that it was missing a full column of data? Find out how to insert a column in Google Sheets and avoid having to manually move all of your data one row to the right, or one row to the left.