How to Group / Ungroup Worksheets (Tabs) in Excel

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on November 26, 2023

This tutorial demonstrates how to group and ungroup worksheets in Excel.

Grouping Intro

If you have multiple worksheets that have the same layout and formatting, grouping these sheets together can be useful; any editing changes done in one sheet are applied to all the other sheets in the group at the same time. Any changes that are made, be it formatting or formulas, are made on all the grouped sheets at the same time without having to switch to any of the other sheets. This can be a great time-saver!

Group Worksheets

Group Adjacent Worksheets

  1. To group adjacent worksheets, first click the sheet tab of the first sheet to be in the group.

Grouping FirstSheet

  1. Hold down the SHIFT key, and then click the last sheet to be in the group.

All sheets between the first and last selected sheet are grouped together.

Group Non-Adjacent Worksheets

  1. To group non-adjacent worksheets, first click the sheet tab of the first sheet to be in the group.
  2. Hold down the CTRL key, and then click the next sheet to be in the group.

Grouping Alternative Sheet

  1. Keep the CTRL key down and continue to click on the sheets you wish to be in the group.

Grouping NonAdjacentGroup

Group All Sheets at Once

  1. To group all sheets in a workbook at once, first right-click on any of the sheet tabs.

Grouping GroupAll

  1. Click Select All Sheets to group all the worksheets in the current workbook.

Grouping AllWorksheets Group

Once the worksheets are grouped, the menu bar indicates Excel is in Group mode.

Grouping MenuBar

Ungroup Worksheets

The easiest way to ungroup worksheets is to click on the worksheet tab of a sheet that is not in the group. This immediately ends group mode.

Alternatively, right-click on any of the grouped sheet tabs and click Ungroup Sheets.

Grouping ungroup sheets

Edit Multiple Sheets at Once

In group mode, when you edit one of the sheets or apply a formula, it automatically applies the change(s) to the rest of the sheets in the group.

  1. Group the sheets that need formatting and/or calculations.

Grouping unformatted

  1. Format the first sheet and enter any calculations. In the example below, the cells are formatted and the SUM Function calculates the totals for each month.

Grouping Formatted

  1. Ungroup the sheets and then click on one of the previously grouped sheets to see the result.

Grouping Formatted Sheet

AI Formula Generator

Try for Free

See all How-To Articles