How to Group Tabs Under a Master Tab in Excel (2 Ways)

In this tutorial, we will group tabs under a master tab in Excel using hyperlinks and VBA.

In the master sheet provided below, the sales records of each employee are conveniently linked to their respective names in column B. By simply clicking on an employee’s name, you will be directed to their individual sales record sheet.

Group tabs under a master tab in Excel

Method 1 – Using Hyperlinks

Hyperlinks create shortcuts to navigate within the workbook or open documents on a network server, intranet, or the Internet with a simple click on a cell.

The “Employee Dataset” sheet below lists the employees’ names under column C. The sales records of each employee are stored in separate tabs. We will hyperlink to these tabs from the list of names.

Showing Data Tabs


  • Enter the names of all tabs to group in the master tab.
    As in the image below, all the employee names are listed in the range C6:C18.Listing all the tab names
  • Select a cell containing a tab’s name.
    Cell C5, containing the name “Samantha Carlson,” is selected here.
  • Press the Ctrl+K keys.
  • In the Insert Hyperlink box that opens:
      • From “Link to” options, choose “Place in This Document”.
      • Choose the tab name from “Or select a place in this document” section.
      • Press OK.
    inserting hyperlink in a cell

    Click on the image for a detailed view.

The selected cell now contains a hyperlink to the sales record tab of that employee. Also, the hyperlinked text is underlined and blue-colored, which makes it easier to differentiate from other texts.

hyperlink inserted into the selected cell

After hyperlinking all the names with designated tabs, the list will appear as shown in the image below. This will allow you to easily navigate to the desired tab by clicking on the respective name.

All tab names hyperlinked

To make your work more accessible, you can add a hyperlink in each tab by linking it with the master tab. This way, when you finish working on a tab, you can quickly return to the master tab. master tab added

Method 2 – Using a VBA Macro

This VBA code is linked to a form control. Selecting that form control will navigate you to the corresponding tab based on its name.


  • Go to the Developer tab > Insert > Button (Form Controls).Selecting Button Form Control
  • Press OK in the Assign Macro box that appears.Press OKA form control button will appear.Button Form Control Appeared
  • Double-click the button and enter a tab’s name.Rename the button
  • Go to the Developer tab.
  • Select Visual Basic from the Code group.Selecting Visual Basic
  • In the VBA window that opens, select Module from the Insert tab.Selecting Module from Insert Tab
  • Paste the following VBA code into the Module:
Sub GoToSheet1()
    Sheets("Samantha Carson").Activate
End Sub
  • Change the sheet name according to the targeted tab name.
  • Go back to the master tab.
  • Right-click on the button.
  • Choose the Assign Macro option from the context menu.Select Assign Macro
  • In the Assign Macro box, choose the macro and click OK.Select Macro and press OK

The macro will be assigned to the button. Now, if you click on the button, it will take you to the assigned tab.

Clicking Button Taking to Desired Tab

Click on the image for a detailed view.

After inserting buttons for one department’s employees’ names, our sheet looks like this:

Button Created for One Group

Read More: How to Create Tabs Within Tabs in Excel

How to Group Tabs in Excel

You can work on multiple sheets at once by grouping tabs in Excel. After grouping tabs, if you make any changes to one sheet, it will be reflected in all sheets in that group.

Grouping tabs is useful to create standardized tables or perform calculations across multiple sheets at once. However, it only works efficiently when the sheets all have the same structure.

In the image below, we have 5 tabs with the sales record of 5 company employees. Each tab’s structure is similar to the one shown below.

Tabs with Employee Names

Here are 3 cases for grouping tabs in Excel:

Case 1 – Grouping Adjacent Tabs

To group several adjacent tabs, click on the first tab and the last tab while pressing the Shift key.

Any changes made in the first tab will be visible in other selected sheets too.

Adjacent Tabs Grouped

Case 2 – Grouping Non-Adjacent Tabs

To group non-adjacent tabs, select the first tab and then select other sheets while holding the Ctrl key.

Non Adjacent Tabs Grouped

Case 3 – Grouping All Tabs

To select all tabs in a worksheet, right-click on any tab and click Select All Sheets from the context menu.

Choosing Select All Sheets Option

How to Ungroup Tabs in Excel

To remove the grouping of tabs after making changes, simply right-click on the tab name and choose the option Ungroup Sheets from the context menu.

Ungrouping tabs

If all sheets are grouped together, you can easily ungroup them by simply clicking on any tab name. However, if not all the sheets are grouped, you can ungroup selected tabs by clicking on any group outside of that particular group.

Download Practice Workbook

Frequently Asked Questions

How do I move a group of tabs in Excel?

To move a group of tabs, simply group them by holding down the Ctrl key and clicking their tab names, then drag them to the desired location.

Can I color-code tabs within the master tab for better visualization?

Yes. Right-click on a tab, choose “Tab Color,” and select a color to visually group related sheets.

How many tabs can you have in Excel?

It depending on the version you are using. In most versions of Excel, including Excel 2019 and Excel 365, you can have a maximum of 1,048,576 tabs in a single workbook.

Related Articles

<< Go Back to Sheets Tab in Excel | Excel Parts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Durjoy Paul
Durjoy Paul

Durjoy Kumar, with a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, is a dedicated contributor to the ExcelDemy project. His substantial contributions include crafting numerous articles and demonstrating expertise in Excel and VBA. Durjoy adeptly automates Excel challenges using VBA macros, offering valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, SPSS, C, C++, C#, JavaScript, Python Web Scraping, Data Entry... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF