X
X
The Best Tech Newsletter Anywhere

Join 350,000 subscribers and get a daily digest of news, geek trivia, and our feature articles.

How to Group Worksheets in Excel

The Microsoft Excel Logo.

If you’re editing multiple worksheets in Microsoft Excel, it might be helpful to group them together. This allows you to make changes to the same range of cells across multiple worksheets. Here’s how to do it.

Grouping Multiple Worksheets in Microsoft Excel

Grouping worksheets together in Excel can be useful if you have an Excel workbook with multiple sheets that contain different data but follow the same layout.

The example below shows this in action. Our Excel workbook, named “School Data,” contains multiple worksheets related to the operation of a school. Three of the worksheets have lists of students for different classes, named “Class A,” “Class B,” and “Class C.”

An Excel workbook with similar worksheets of "Class A," Class B," and "Class C."

If we group these worksheets together, any actions we perform on any of these worksheets will be applied to all of them.

For instance, say we want to insert an IF formula in column G (cells G4 to G12) on each worksheet to determine whether any students were born in either 1998 or 1999. If we group the worksheets together before we insert the formula, we can apply it to the same range of cells on all three worksheets.

RELATED: How to Use Logical Functions in Excel: IF, AND, OR, XOR, NOT

To group worksheets together, press and hold the Ctrl key and click each worksheet you want to group together at the bottom of the Excel window.

Three worksheets selected at the bottom of an Excel window.

Grouped worksheets appear with a white background, while unselected worksheets appear in gray.

The example below shows the IF formula we suggested above inserted in the “Class B” worksheet. Thanks to worksheet grouping, the same formula was inserted in cells G4 to G12 on the “Class A” and “Class C” worksheets, too.

An Excel IF formula, applied to multiple grouped worksheets.

If we further modify any of these cells—like by adding a second set of formulas to column H—the change will be applied to all the grouped worksheets simultaneously.

Grouping All Worksheets in Microsoft Excel

When you press and hold Ctrl, you can select multiple individual worksheets and group them together. If you have a much larger workbook, though, this is impractical.

If you want to group all the worksheets in an Excel workbook, you can save time by right-clicking one of the worksheets listed at the bottom of the Excel window.

From here, click “Select All Sheets” to group all your worksheets together.

Click "Select All Sheets."

Ungrouping Worksheets in Microsoft Excel

After you’ve finished making changes to multiple worksheets, you can ungroup them in two ways.

The quickest method is to right-click a selected worksheet at the bottom of the Excel window, and then click “Ungroup Sheets.”

Click "Ungroup Sheets."

You can also ungroup individual sheets one at a time. Just press and hold Ctrl, and then select the sheets you want to remove from the group. Worksheet tabs you ungroup will return to a gray background.

Ben Stockton Ben Stockton
Ben Stockton is a freelance tech writer from the United Kingdom. In a past life, he was a UK college lecturer, training teens and adults. Since leaving the classroom, he's been a tech writer, writing how-to articles and tutorials for MakeUseOf, MakeTechEasier, and Cloudwards.net. He has a degree in History and a postgraduate qualification in Computing.
Read Full Bio »

The above article may contain affiliate links, which help support How-To Geek.
How-To Geek is where you turn when you want experts to explain technology. Since we launched in 2006, our articles have been read more than 1 billion times. Want to know more?

x

The Best Tech Newsletter Anywhere

Join 350,000 subscribers and get a daily digest of news, comics, trivia, reviews, and more.