Exam 77-420 Microsoft Excel 2013
1. Create and Manage Worksheets and Workbooks
1.3 Format Worksheets and Workbooks: Group or Ungroup Worksheets

graphic1
 
graphic2

Group the Worksheets

One last example. Say you have a collection of sheets that belong together. There is a new Group function in Microsoft Excel that allows you to manage those sheets together.

 

Try This: Group Many Sheets

This sample workbook has several sheets.

Select the first sheet.

Hold the CONTROL key on the keyboard.

Select the second, third and fourth sheets.

 

What Do You See? This set of sheets is now a Group. When you Move one, you Move them all together. A cursor and a stack of pages will follow your mouse as you move across the tabs.

 

Try This, Too: Ungroup the Sheets

Right click the Group.

Click on Ungroup Sheets.

The Sheets will be independent, again.

pic1