Grouping Worksheets in Excel: A Step-by-Step Tutorial

Download Article

Edit multiple worksheets at once by grouping them together

Written by Kyle Smith

Last Updated: June 26, 2023

Download Article

• Grouping & Ungrouping Selected Worksheets (PC)
|
• Grouping & Ungrouping All Worksheets (PC)
|
• Grouping & Ungrouping Selected Worksheets (Mac)
|
• Grouping & Ungrouping All Worksheets (Mac)
|
• Tips

|Show more |Show less

Grouping Excel worksheets allows you to make the same edit to every worksheet at the same time. You can select a few sheets to group, or add all worksheets in your workbook to a group. To group multiple worksheets, hold down Ctrl (PC) or Cmd (Mac) as you click the tab of each worksheet. When you're done, ungroup the sheets by holding down Ctrl or Cmd and clicking the tabs of the sheets you want to remove. This wikiHow guide will show you how to group and ungroup worksheets in Microsoft Excel 365, 2019, and all other versions of Excel, for Windows or Mac.

Things You Should Know

• To group multiple sheets, hold down Ctrl as you click each worksheet's tab.
• To group all worksheets in your workbook, right-click any worksheet tab and choose "Select All Sheets."
• To remove a worksheet from the group, hold down Ctrl as you click the worksheet's tab.

Steps

Method 1

Method 1 of 4:

Grouping & Ungrouping Selected Worksheets (PC)

Download Article

1. 
   1
   Hold down Ctrl as you click the tabs you want to group. You'll see the tabs for each worksheet at the bottom of your workbook. This adds the selected worksheets to a group, which allows you to make the same edits to each sheet at the same time. The grouped worksheet tabs will turn white to show that they are grouped.

   • For example, if you make a spreadsheet with five worksheets listing your monthly expenses (e.g., January, February, and March, April, May), you could select January and March to group them.
   • Once the worksheets are grouped, any changes you make to one worksheet will apply to all worksheets in the group. For example, if you create a subtraction formula in the January worksheet, the same formula will appear in the March worksheet.
2. 
   2
   To ungroup, hold down Ctrl as you click each grouped tab. When you're finished making changes to the group, you can easily remove worksheets from the group just as you grouped them.
Advertisement

Method 2

Method 2 of 4:

Grouping & Ungrouping All Worksheets (PC)

Download Article

1. 
   1
   Right-click a tab for a worksheet. This will open a pop-up menu.

   • Use this method to group every worksheet in the current workbook. For example, if you have five worksheets listing your monthly expenses (e.g., January, February, March, April, May), this method will group all five months together so you can quickly make changes to all months at once.
2. 
   2
   Choose Select All Sheets. This will group every worksheet in your workbook. The grouped worksheet tabs will turn white.

   • Any edit you make to a worksheet in the group will be applied to every worksheet. For example, if you create a summation formula in the January worksheet, the formula will be applied to the other five months as well.
3. 
   3
   Ungroup the worksheets. When you're finished making changes, ungrouping the worksheets is easy:

   • Right-click the tab for any worksheet in the group.
   • Select Ungroup Sheets.
Advertisement

Method 3

Method 3 of 4:

Grouping & Ungrouping Selected Worksheets (Mac)

Download Article

1. 
   1
   Hold down Cmd as you click the tabs you want to group. You'll see the tabs for each worksheet at the bottom of your workbook. This adds the selected worksheets to a group, which allows you to make the same edits to each sheet at the same time.

   • For example, if you have a workbook with 12 worksheets for individual months, you can select the February and November tabs to group them.
   • Once the sheets are grouped, changes you make to one worksheet will apply to all worksheets in the group.
2. 
   2
   To ungroup, hold down ⌘ Cmd as you click each grouped tab. After making changes to the group, you can easily remove worksheets from the group just as you grouped them.
Advertisement

Method 4

Method 4 of 4:

Grouping & Ungrouping All Worksheets (Mac)

Download Article

1. 
   1
   Right-click a tab for a worksheet. This will open a pop-up menu.

   • Use this method to group every worksheet in the current workbook in Excel for macOS.
2. 
   2
   Click Select All Sheets. This will group every worksheet in your workbook. All grouped worksheet tabs will turn white.

   • Any edit you make to a worksheet in the group will be applied to every worksheet.
3. 
   3
   Ungroup the worksheets. When you're finished making changes, ungrouping the worksheets is easy:

   • Right-click the tab for any worksheet in the group.
   • Select Ungroup Sheets.
Advertisement

Expert Q&A

Search

Add New Question

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Advertisement

Tips

• The grouping feature is especially helpful for quickly applying complex functions (like VLOOKUP) to multiple worksheets.
  Thanks

  Helpful 0 Not Helpful 0

Submit a Tip

All tip submissions are carefully reviewed before being published

Name

Please provide your name and last initial

Submit

Thanks for submitting a tip for review!

Advertisement