How to group worksheets in excel?
I need to group and ungroup selected/all worksheets.
How I can group or ungroup selected or all worksheets?
Solution(step by step)
Group selected worksheets in excel
Press and hold down the Ctrl key, and select worksheet tabs you want to group.
Ungroup selected worksheets
Press and hold the Ctrl key, and click the selected worksheet tabs that you want to ungroup.
Group all worksheets
Right-click any worksheet tab and then Click Select All Sheets.