Group Excel Worksheets

Grouping is one of the useful features of Excel to consolidate the worksheetsExcel To Consolidate The WorksheetsConsolidate is an inbuilt function in excel which is used to consolidate data from different workbooks which are opened at the same time. It allows to select multiple data from different workbooks and consolidate it in a final workbook.read more to work concurrently on the different worksheets. As a result, tasks are accomplished quickly using the group worksheets.

Explained

  • 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.

Examples

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.

  • In the first step, we must select any tab we wish by clicking on it. Right-click on the worksheet tab and select the last option, “Select All Worksheets.” The below figure helps understand the group’s process of all worksheets.

The below figure helps understand the group’s process of all worksheets.

  • 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.

How to Use Group Worksheets in Excel?

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 ExcelSUM Formula In ExcelThe SUM function in excel adds the numerical values in a range of cells. Being categorized under the Math and Trigonometry function, it is entered by typing “=SUM” followed by the values to be summed. The values supplied to the function can be numbers, cell references or ranges.read more 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.

Things to Remember

  • Tip1: 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.Tip2: The user should confirm whether grouping is applied or not by checking the file’s name in the title bar ([Group] is added).Tip3: We should present at least two sheets in the workbook to make a group of worksheets together in Excel.Tip4: 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 WorksheetsAverage FormulaExcel Worksheet TabHow to Column Sort in Excel?Split Excel CellsHow to Copy Worksheet in Excel?AutoFit Excel