Group Worksheets In Excel

Group Excel worksheets is one of the useful features of Excel to consolidate the worksheets to work concurrently on the different worksheets. As a result, tasks are accomplished quickly using the group worksheets.

For example, consider the below workbook with 3 worksheets, Test 1, Test 2, and Test 3 respectively. Now, we can learn how to group these sheets.

Step 1: First, press Ctrl key and select the sheets – Test 1, Test 2, and Test 3.

Immediately, we can see the name of the workbook is indicated as a group as shown in the below image.

Likewise, we can group sheets in Excel.

• Grouping sheets in Excel is performed while working with multiple sheets with calculations.
• Using grouping sheets in Excel, we can save a lot of time and work effortlessly.
• It is because we can work on all the sheets simultaneously.
• Grouping sheets in Excel enhances data accuracy and reduces potential errors.
• Remember, we can group all the sheets or select consecutive sheets also in Excel.
• The option, of grouping sheets in Excel, is widely used in educational institutions, managers, and in businesses.

• Changes made in one worksheet can together change in other worksheets in Excel. Grouping saves a lot of time for Excel users to perform calculations or create complex tables with large data and edit and format the sheets.
• It gives the best results to users when the same type of data is presented in the cells of the same addresses. Grouping also improves the accuracy of data and eliminates the error made by a human in performing the calculations.
• Business owners and managers widely use it to update data in similar worksheets. In the present article, the following things are explained clearly.

The following examples are provided for understanding how grouping works together in Excel. Grouping is used mainly in six ways:

Example #1 – Group Individual Worksheets

One must press and hold down the “CTRL” key on the keyboard for individual group worksheets and simultaneously select the sheets individually by clicking on each tab. After completing grouping, all the tabs presented in the Excel workbook are converted into white color. Finally, the file name is added with the group in the title bar, as shown in the figure below.

Example #2 – Ungroup Individual Worksheets In Excel

If we do not want a group of sheets together in Excel, we can ungroup them by again holding the “CTRL” key or clicking on other Excel sheets, removing the grouping.

Example #3 - Group All Worksheets

Example #4 – Ungroup All Worksheets In Excel

Ungrouping worksheets together in Excel is easy by using any one of the following steps.

• Step 1: Right-click on the tab and select the “Ungroup Worksheets” Excel option.

• Step 2: Clicking on any other sheets immediately also ungroup every sheet in the workbook.

Example #5 - Group Consecutive Worksheets

To group the consecutive worksheets in Excel:

• The user must click the first worksheet to activate it.

• Press and hold the “Ctrl” button from the keyboard and select the last worksheet tab by clicking with the mouse.

Example #6 - Ungroup Consecutive Worksheets In Excel

To ungroup consecutive worksheets in excel,

• We must right-click on the first or last tab of the activated worksheet and select the “Ungroup Worksheets” Excel option.

• Clicking on any other sheets immediately also ungroups every sheet in the workbook.

The Excel sheet shows that the following sample data explains how to group worksheets in Excel.

Suppose we want to obtain the value of total car sales in February, March, April, and January.

So, first, we need to group all the sheets, group individual sheets, or select all worksheets at a time.

Then SUM Formula in Excel in the C11 cell of the January worksheet.

The total sales value is automatically calculated in other worksheets and January month. The results are obtained, as shown in the below-mentioned figures.

The text and formula are automatically applied to other sheets if we add an average formula in the next row of total sales.

Average sales are automatically calculated in other worksheets along with January month. The results are obtained, as shown in the below-mentioned figures.

Suppose we delete a row or column in the January worksheet after grouping.

For example, we have deleted the row header in the January worksheet in the below screenshot. The same changes are applied to other worksheets in Excel.

• The user needs to use only an active tab to add formulas and apply the format to sheets to utilize the grouping method best. Using another tab cannot generate the required results.
• The user should confirm whether grouping is applied or not by checking the file’s name in the title bar ( is added).
• We should present at least two sheets in the workbook to make a group of worksheets together in Excel.
• Do not browse through the sheets not included in the group immediately after grouping the sheets. It leads to the ungrouping of the sheets directly.

This article is a guide to Grouping Worksheets in Excel. Here, we discuss how to group worksheets and use them concurrently to save time. Also, we discuss how to ungroup worksheets in Excel. You may learn more about Excel from the following articles: -

• VBA Worksheets
• Average Formula
• Excel Worksheet Tab
• How to Column Sort in Excel?
• Split Excel Cells
• How to Copy Worksheet in Excel?
• AutoFit Excel