How to Group Worksheets in MS Excel

When you’re working on multiple worksheets in Excel, you may need to perform the same task on all the worksheets. Opening each worksheet and repeating this task can be incredibly time-consuming. 

Fortunately, MS Excel allows you to group worksheets. This will allow you to perform the same operation on all the selected worksheets in one go.

2 Methods of grouping worksheets in Microsoft Excel:

  • Grouping worksheets using the Ctrl or Cmd key
  • Grouping worksheets by selecting all the sheets

Let us begin.


Method #1: Group Worksheets Using the CTRL or CMD Key

If you have only a set of specific worksheets to be grouped, you can use this quick method.

Step #1: Open your Excel workbook

Open the Excel workbook that contains the multiple worksheets to be grouped.

If you don’t have an existing workbook, create a new one and tap on the plus icon at the bottom to create new worksheets.

Step #2: Press and hold CTRL or CMD key

Your workbook currently displays Sheet1 as the active sheet.

Now press and hold the Ctrl key if you use Windows. 

Long-press the Cmd key if you’re a Mac user.

Step #3: Select the sheets

While you’re holding the Ctrl or Cmd key, click on the other sheets that you want to include in the group. 

Once done, all the selected sheets will be highlighted. 

In our example, Sheet1 is the active sheet. Sheet1, Sheet2, and Sheet3 are selected and grouped. Sheet4 is not selected.

Step #4: Perform the required operations

Now, perform the operations that you want on all the selected sheets. Let’s assume this is an attendance sheet for three classes. So, all the selected sheets would have the same headers for uniformity. So, on any of the sheets, type the details or perform the required calculations. 

In this instance, let’s enter the headers on Sheet1.

Step #5: Check if the changes have been applied to all the selected worksheets

Now, check the other sheets to see if the same headers have been added. 

In this instance, we entered the details in Sheet1. Let’s check if it’s been replicated on the other two selected sheets. As we can see, Sheet2 displays the same headers as Sheet1.


Method #2: Group Worksheets by Selecting All the Sheets

Use this method if you want all the worksheets in a workbook to be grouped.

Step #1: Open your Excel workbook

Open a new Excel workbook and create new worksheets to be combined. If you already have one with multiple worksheets, open that Excel workbook.

Step #2: Right-click on any sheets

Right-click on any of the sheets. In this instance, let’s right-click on Sheet1.

Step #3: Click on Select All Sheets.

Once you right-click on a sheet, you will see a list of options. 

From the list, click on Select All Sheets.

Now, all the sheets will be selected.

Step #4: Perform the required operations

Now, perform the operations that you want on all the selected sheets. For our example, we will add headers. So, all the selected sheets would have the same headers for uniformity. 

In this instance, let’s enter the headers on Sheet1.

Step #5: Check if the changes have been applied to all the selected worksheets

Check if the changes have been applied to all the selected worksheets.


Conclusion

Performing the same task on every worksheet is tedious and time-consuming. Now that you know two ways to use the Excel feature of grouping worksheets, you can make changes to all of them in one go.

Leave a Comment