How to group worksheets in Excel [in easy steps]

November 3, 2021

This article explains how to group worksheets in Excel. You may want to do this to quickly edit multiple worksheets simultaneously, perform the same calculation on multiple sheets, correct typos, or copy a group of sheets.

To group sheets in Excel:

  1. Hold down the CTRL key and click each of the tabs one by one
  2. When you are satisfied with your selection, release CTRL key

If you want to group consecutive (adjacent) worksheets, click on the first sheet tab, press and hold the SHIFT key, and click the last sheet tab that you want to include in your selection.

How to group worksheets in Excel

How do you tell if sheets are grouped?

When working with grouped worksheets, it is essential to realize that any changes to the active sheet will also affect the rest of the selected worksheets.

In the image above, you can see that the word [Group] is shown next to the file name (in the upper Excel bar). The tabs corresponding to the selected worksheets are also highlighted with a white background. Any sheet tabs outside the group appear in gray.

How to group all worksheets in a workbook

Follow these two simple steps to group all worksheets in a workbook:

  1. Right click on any worksheet tab to open the ribbon
  2. Click on Select All Sheets to group all the Excel worksheets
How to group all worksheets in a workbook

How to ungroup worksheets in Excel

Ungrouping worksheets in Excel is just as simple:

  1. Hold down the CTRL key
  2. Click on each of the worksheets that you want to ungroup
  3. Release the CTRL key

Alternatively, you can also ungroup selected worksheets in two easy steps:

  1. Right click on any of the selected worksheet tabs
  2. Click on Ungroup Sheets to ungroup all the Excel worksheets

To ungroup all worksheets, you can also click any worksheet tab outside the group.

How to ungroup worksheets in Excel

Advantages of grouped sheets in Excel

Whenever you are working with identical sheets, grouping and editing them all at once can save you a lot of time. Once you have grouped the worksheets, editing the active sheet will make the same changes on all the other sheets.

Here are a few situations when it makes sense to select and work with multiple worksheets at once:

  • Edit or add new data on several identically structured sheets of an Excel workbook
  • Edit or add new formulas that use the same cells
  • Correct a typo or mistake on several sheets
  • Apply the same formatting to all the worksheets at once
  • Print a selection of worksheets
  • Move, copy, or delete multiple worksheets
Editing multiple worksheets at once

What to do next?

I hope that this article was short and clear and that it showed you, step by step, how to group worksheets in Excel. I publish these Excel tutorials because I truly want you to get better. That is why, if you have additional questions on how to use grouped sheets, please leave a comment, and I'll help you out as soon as possible.

The easiest way to learn Excel is by solving problems, so I have created a dedicated section with useful Excel formulas to help you practice. You can also enhance your Excel knowledge with weekly lessons delivered straight to your inbox. Just fill in the form below, and you'll receive one Excel tutorial every Monday.

Thousands of people have benefited from my free Excel lessons. My only question is, will you be next?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Essential Functions

Excel Topics

Excel courses

I have compiled a list of the best Excel online courses. It covers basic and advanced topics, VBA, and Power BI.
View courses
Excel is a very complex application, and understanding it on your own may prove difficult and time-consuming. I have created ExcelExplained.com to help you better understand each function and provide useful examples for different tasks. If you can’t find the answer to your question in one of the published articles, please leave a comment or send me an email, and I will do my best to help you out.

Affiliate Disclosure: When you purchase a product through a link on our website, I may earn an affiliate commission. There are no additional costs to you.
Copyright © 2017-2021 ExcelExplained.com