How to group worksheets in excel?

Posted on 28-02-2020 , by: admin , in , 0 Comments

How to group worksheets in excel?

Problem
I need to group and ungroup selected/all worksheets.

Question
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.

HOW TO GROUP WORKSHEETS IN EXCEL?

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.

HOW TO GROUP WORKSHEETS IN EXCEL?
Tip: If you want to group consecutive worksheets, select the first worksheet , press and hold the Shift key, select the last worksheet tab in the range. If you group two selective worksheets, and if you make changes in one of those worksheet then same changes will reflect in other worksheet.

Example:

Formula change to the Paris worksheet in 7th row is automatically made changes to the London worksheet
Paris Worksheet: :

London Worksheet:

Ungroup all worksheets “Right-click any worksheet tab in the all worksheet group and then Click Ungroup Sheets.” Tip: To ungroup all worksheets from group, you can also click any worksheet tab outside the group.

Leave a comment