When you make a workbook in Google Sheets that contains a lot of worksheet tabs, finding the important ones can be difficult. In some cases you might actually need to access every tab in your worksheet but, in other cases, there might be some old tabs, or tabs that are just for formula references, which probably don’t need to be visible.
These situations are great options for hidden tabs. A hidden tab in Google Sheets is still actually a part of the file, but it’s hidden from view so that the tab isn’t taking up space, and so that you don’t accidentally edit information on the wrong tab. Our guide below will show you how to hide a worksheet tab in Google Sheets.
How to Hide a Worksheet in Google Sheets
The steps in this article are going to show you how to hide an existing tab in a Google Sheets file. You will still be able to create formulas that use cells in this hidden worksheet, and you will be able to unhide the worksheet later, if you so choose.
Step 1: Sign into your Google Drive and open the Google Sheets file containing the worksheet tab that you would like to hide.
Step 2: Locate the worksheet tabs at the bottom of the window.
Step 3: Right-click on the worksheet tab that you want to hide, then select the Hide sheet option.
You will also see a little popup that tells you how to find and unhide worksheets later but, in case you would like to see those steps as well, then find out how to unhide in Google Sheets if you find that you need to edit something, or view something, on a sheet that is hidden.