How To Ungroup Worksheets - To group adjacent worksheets, first click the sheet tab of the first sheet to be in the group. Web select sheet1, press down the shift key, and select sheet4. Web how to group / ungroup worksheets (tabs) in excel group worksheets. Web hold the ctrl key and click on a grouped sheet to ungroup it. Group sheets with the shift key using the shift key to group worksheets is a better option when you want to group many consecutive sheets in. Web after you've made the desired changes, you can ungroup the worksheets in this way: From the context menu select ungroup sheets. Here, you will see all the grouped worksheets. This will select all four sheets and group them together.
From the context menu select ungroup sheets. To group adjacent worksheets, first click the sheet tab of the first sheet to be in the group. Web after you've made the desired changes, you can ungroup the worksheets in this way: Web hold the ctrl key and click on a grouped sheet to ungroup it. Web how to group / ungroup worksheets (tabs) in excel group worksheets. Group sheets with the shift key using the shift key to group worksheets is a better option when you want to group many consecutive sheets in. Here, you will see all the grouped worksheets. Web select sheet1, press down the shift key, and select sheet4. This will select all four sheets and group them together.