microsoft office excel

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:

  • Click on the Sheet1 tab.
  • Press and hold the SHIFT key on your keyboard.


  • As a result in above snapshot, you will find that the name of the workbook in title bar has been changed to Group.
  • The sheets are now grouped.
  • You can perform any actions required, and these will be replicated in each selected sheet.


To select Sheet1 & Sheet3 a group of non-neighboring worksheets:


  • Click on the Sheet1 tab.
  • Press and hold the CTRL key on your keyboard & select Sheet3.


The worksheets are now grouped.


To select all the sheets in the workbook:

  • Right-click on any worksheet tab & click on Select All Sheets


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:

  • Right click to grouping worksheet in the Excel, then select Ungroup Sheets


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.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published.