In this article:

How to Group Tabs in Google Sheets (Easiest Way in 2024)

Can You Group Tabs in Google Sheets?

You can group tabs in Google Sheets, but the functionality may not be what you expect if you're thinking of visually grouping tabs within the Sheets interface. 

Google Sheets does not directly support visually grouping tabs (sheets) together in the bottom tab bar. However, you can organize your work in a way that achieves a similar effect through a few methods. We will use these methods in the succeeding sections. 

How to Group Tabs in Google Sheets

Follow the steps below to group tabs in Google Sheets. 

1. Color Code Tabs for Visual Grouping

Right-click on a sheet tab at the bottom. Select "Change color" and choose a color. This visually groups tabs by color.

google sheets group tabs

2. Name Tabs Using Prefixes for Logical Grouping

Name your tabs with prefixes to group them. Right click your tab then select 'Rename'. For example, use "1-Finance" for finance tabs and "2-Marketing" for marketing tabs.

group tabs in google sheets

3. Create a Clickable Table of Contents Sheet within Your Google Sheet

Start by adding a new sheet by clicking the '+' icon.

can you group tabs in google sheets

Name the new sheet as 'Table of Contents.

how to group tabs in google sheets

In the first column, list the names of the tabs you want to link to. 

group tabs google sheets

In the second column, use the HYPERLINK function to create clickable links. To find the link to a tab:

Click on the tab you want to link to.

Look in the browser's address bar for the URL. It will end with something like #gid=123456789.

In the "Table of Contents" sheet, next to the tab name, enter =HYPERLINK("#gid=123456789", "Tab Name") replacing 123456789 with the actual gid number and "Tab Name" with the name of the tab.

4. Link Your Google Sheet to Other Google Sheets for Cross-File Navigation

If tabs are unrelated, consider using separate Sheets files. Link between them using the HYPERLINK function, for example, 

=HYPERLINK("https://docs.google.com/spreadsheets/d/your_sheet_id", "Go to Marketing Sheet").

We hope that you now have a better understanding of how to group tabs in Google Sheets. If you enjoyed this article, you might also like our article on the arrayformula filter in Google Sheets or our article on how to add video to Google Sheets.

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started