Arrow left
Back to product guides
Google Sheets Tips

How to Hide a Tab in Google Sheets

In this post, you will learn how to make a tab invisible in Google Sheets. 

This function is helpful when you organize tabs as you can make irrelevant and unnecessary sheets invisible but still keep them in the file. You should be aware that a hidden sheet can be unhidden. So, we recommend you delete any irrelevant sheets or any other sheets which you don’t want others to see from a Google Sheets file instead of just hiding them by using this function.

How to hide a worksheet in Google Sheets

  1. Right-click the tab of the worksheet you want to hide.
  2. Select “Hide sheet”.
How to hide a worksheet in Google Sheets

How do I hide multiple tabs in Google Sheets?

  1. You can hide multiple tabs at the same time. If they are adjacent, click the first tab and then the last tab in the range you want to select while pressing the “Shift” key. If they are not adjacent while pressing “Ctrl (or Command in Mac)”, click the tabs you want to pick up.
  2. Right-click and select “Hide sheets”.

Can I hide and lock a tab in Google Sheets?

Yes, you can hide and protect a tab in Google sheets. Refer to this article about how to protect a sheet. You can hide a locked sheet in the same way as normal sheets. 

How do I show hidden tabs in Google Sheets?

  1. Go to “View” in the menu bar at the top.
  2. Tap “Hidden sheets (X)” and click the sheet you want to show.
How to unhide a hidden sheet in Google Sheets

Tiding tabs would be beneficial when you share Google Sheets with various departments and you have many viewers because everyone can go straight to key tabs. If you are interested in a well-organized spreadsheet that allows you to intergrate multiple sets of financial data by department and share the gathered inforamtion among members in real time, LiveFlow may be beneficial for you. Check the following use case as well: Give department leaders visibility of their P&L.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at:
Check Icon
Call us at +1 (415) 650-1711