How to group worksheets in Excel – 2 easy methods

Logo of pk guide featuring a stylized green square with a white 'x' superimposed, designed to represent group worksheets in Excel, against a gradient blue background.

You can trust PC GuideOur team of experts use a combination of independent consumer research, in-depth testing where appropriate – which will be flagged as such, and market analysis when recommending products, software and services. Find out how we test here.

Last Updated on

Wondering how you can group worksheets in Excel to save time? Well, we’ve got you covered with two methods.

If you constantly deal with multiple sheets and have to make the same changes on every sheet, you may want to consider grouping them together. This can help you make changes to all sheets simultaneously, ultimately saving you time.

In this guide, to make things easier for you, we’ll explain the process of grouping worksheets in Excel.

1

How to group selected worksheets in Excel

Grouping worksheets in Excel is a pretty straightforward process. Just follow these simple steps and you’ll be set up in no time.

Step

1

Open your Excel workbook

First, open your Excel workbook.

Screenshot of a group of Excel worksheets displaying product data with models and corresponding numerical values in a table format on a computer screen.
Workbook

Step

2

Start grouping the sheets

Now, you want to hold down CTRL and click all the sheet tabs you want to group. You can either select all of them or only a few. For the latter, you can click on Sheet 1 and Sheet 3, and they will be grouped together.

Excel interface displaying three grouped worksheet tabs labeled sheet1, sheet2, and sheet3; sheet1 is selected.
Selecting worksheets

Step

3

Release the CTRL button

Release the CTRL button, and your worksheets will be grouped. After that, whatever you add in one sheet will be added to the other one, as long as it belongs to the group. Just make sure not to browse through the sheets, as this will ungroup them.

2

How to group all worksheet n Excel

You can also group all the worksheets in a workbook, which is even easier to do than selected worksheets. This is useful for those who want to group more than 10 sheets quickly.

Step

1

Right-click any of the existing worksheets

Right-click any of the existing worksheets.

Step

2

Select ‘All Sheets’

Then click ‘Select All Sheets’. This will group all of them. Again, if you start browsing through the sheets, they will get ungrouped automatically.

Screenshot of an Excel spreadsheet with a right-click menu open, highlighting the "group worksheets in Excel" option.
‘Select All Sheets’ option

If you want to ungroup them, right-click on one of the sheets again and select ‘Ungroup sheets.’

Screenshot of an Excel workbook interface with a right-click context menu open on the "sheet1" tab, highlighted to show the "group worksheets" option.
‘Ungroup Sheets’ option

Benefits of grouping worksheets in Excel

There are multiple benefits to grouping worksheets. Because grouping worksheets allows you to enter the same data, make the same changes, and write all the same formulas across all the worksheets simultaneously, it saves you a lot of time and hassle and is a lot faster than editing each worksheet individually.

Some other benefits include:

  • Being able to set up the same header, footer, and page layout. 
  • Simultaneous printing of multiple worksheets. 
  • Copy, delete, or move a group of worksheets.
  • Correct multiple typos across all worksheets in one go. 
  • Edit or add any required data across each worksheet. 
  • Create or edit any formulas in any cells at the same time. 
  • Delete any unneeded data simultaneously.
  • Change multiple cells across all worksheets. 

Conclusion

Grouping selected worksheets in Excel is a massive game changer for those who work with Excel frequently in their daily lives. When you have multiple worksheets and workbooks to sort through and edit, it might seem like a daunting task if you don’t have the knowledge to sort them faster, but this trick will save you a lot of stress and time. 

Learn more about how Excel works through these guides:

Kevin is the Editor of PC Guide. He has a broad interest and enthusiasm for consumer electronics, PCs and all things consumer tech - and more than 15 years experience in tech journalism.