Exam 77-882: Microsoft Excel 2010 Core

4. Managing Worksheets and Workbooks

 4.1. Create and format worksheets: Group or Ungroup a Sheet

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.