In this article, we will learn Excel grouping and Excel Ungrouping sheets in Microsoft Excel 2010.
Grouping and Ungrouping sheets in excel is a way to perform a task quickly in one sheet & it will automatically update in the selected sheets. It saves time & eliminates any error if you want the graphical objects to be in the same position in every sheet as you perform in the master sheet. To prevent this, you can use grouping feature in sheets.
Consider you are working on large number of sheets in a workbook, if you want to perform any action on one sheet & you want the selected sheets to be able to perform the same task at the same time, you can use grouping feature in Excel.
By using this grouping/un-grouping property of Excel, you can work with flexibility to work on an individual sheet or you can work with multiple sheets at same point of time. Worksheets can be combined into a group. Any changes made to one worksheet in a group will be made to every worksheet in that group.
How to group sheets in Excel?
To select the multiple sheets in a workbook, you need to follow the below-mentioned steps:
To select Sheet1 & Sheet3 a group of non-neighboring worksheets:
To select all the sheets in the workbook:
Note:- Excel shows you worksheets that you select by turning their sheet tabs white (although only the active sheet’s tab name appears in bold) and displaying [Group] after the file name of the workbook on the Excel window’s title bar.
How to ungroup in Excel?
To Ungroup All Worksheets when you finish your group editing, follow these steps:
The worksheets will be ungrouped. Alternatively, you can simply click a non-selected (that is, grayed out) worksheet tab. And all the grouped sheets in the workbook will be ungrouped.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.