Grouping Worksheets

1. Click the first worksheet tab.
   
   
   
2. Hold the Ctrl key and click other tabs to add them to the group.
   
   
   

While grouped, changes to one worksheet apply to all in the group.

Ungrouping Worksheets

• Right-click a grouped worksheet and select Ungroup Sheets.
  
  
  
• Or click a tab outside the group to ungroup all worksheets.
  
  
  

These features help organize and simplify working with large data in Excel.