How to Group and Ungroup Worksheets (Sheets) in Excel


- Written by Puneet

Grouping worksheets in Excel is often used when you have a set of identically structured sheets, and you want to edit those sheets at the same time for this, the best option to edit those multiple sheets at a time is grouping worksheets.

Grouping worksheets when you edit, delete, add, or do anything in one sheet that similarly happens in other grouped sheets at the same time saves you a lot of time.

Let’s assume an example that you have a company that manufactures car interior accessories, and their variable cost slightly varies every month. In this case, if your data set format is constant for each month and after some months you want to see the overall cost for each month then you just simply need to group those sheets and once you enter the formula in any of the sheets to find the overall cost, the formula at the same time copies in all the grouped sheets thus will save time in entering or copying the formula in every sheet one by one.

You can also use the grouping worksheets option for hiding multiple sheets at once instead of hiding them one by one.

Steps to Group Worksheets in Excel

  1. First, hold down the control key from your keyboard.
  2. After that, click the sheet tabs (one by one to select) you want to group.
  3. Now, you need to release the control key.
  4. At this point, all the selected sheets are grouped.

If the worksheets you want to group are adjacent click the first sheet tab, hold down the Shift key, and click the last sheet tab.

Group All Worksheets

  1. First, right click on any sheet tab within the workbook.
  2. After that, you will get a pop-up with multiple options.
  3. Now, choose the “Select All Sheets” option.
  4. At this point, all your sheets within the workbook are grouped.

Ungroup Worksheets

  1. First, right click on any sheet tab in the group.
  2. After that, you will get a pop-up with multiple options.
  3. Now, choose the “Ungroup Sheets” option.
  4. Finally, your workbook is ungrouped.

You can also just click any sheet tab outside the group and the grouped tabs become ungroup.

How to Find IF Worksheets are Grouped in Excel

  1. You will always find the word “Group” in the file name if the sheets are grouped in that workbook.
  2. You will find the white background color of all the grouped tabs unless no one has changed the tab color of any worksheet tab.
Last Updated: August 10, 2023