Grouping is one of the useful features of Excel 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
ExamplesThe following examples are provided for understanding how grouping works together in Excel. Grouping is used mainly in six ways: Example #1 – Group Individual WorksheetsOne 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 ExcelIf 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 WorksheetsIt is easy to group all the worksheets in Excel, following only two simple steps.
Example #4 – Ungroup All Worksheets in ExcelUngrouping worksheets together in Excel is easy by using any one of the following steps.
Example #5 – Group Consecutive WorksheetsTo group the consecutive worksheets in Excel:
Example #6 – Ungroup Consecutive Worksheets in ExcelTo ungroup consecutive worksheets in excel,
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 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
Recommended ArticlesThis 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: – |