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.
When you group sheets in Excel they become ungrouped as soon as you move from one sheet to another. How do you group sheets so they remain grouped as select another sheet. In Lotus 123 this was very easy and it meant that navigation, copying and selecting styles between large numbers of grouped sheet was easy not so in Excel it seems.
I have used Lotus 123 for 35 years and I am finding that Excel not as easy to use particularly in printing generaly and grouping sheets. I have created a group of about 100 sheets and all the sheets from 3 onward take there layout from sheet 3. If I move the curser to say, cell A4, the curser will appear on the same cell when I move between sheets; if I insert a row in 3 this is added to all the other sheets and formulae are adjusted by the change. How do I group sheets in Excel?
Wilk this save multiple worksheets? I have 3 worksheets and need to save all of them when closing them to two different save locations.
Excel document is blurred when open on windows 10 and some of windows 7 machines, office 2016, the excel document has some embedded sheets ... I doubt so! Any suggestions, when we double click on the excel sheet it opens with the original document with all tabs, my client requirement was just to send out the output excel sheet and not the whole sheet ...
That was very helpful thanku
I can see how this works, but I have a spreadsheet that I no longer want the files grouped, which is easy after opening. But every time I open the file the sheets are grouped, and I can't find a way to save the workbook without the grouped sheets re-appearing when I open a later time.
Hi Pete,
Kindly share more details about this spreadsheet. This spreadsheet is used by multiple user or not, or whether this spreadsheet contains macro in it or not.
There can be chance that some macro code must be running which result in grouping of sheets before closing or before opening. You can check following two procedure in thisWorkbook in VB Editor and edit the macros according to your requirement.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Private Sub Workbook_Open()
Regards
Ramandeep Singh
awesome..thanks for sharing this
Good for printing a number of sheets as one document