Excel: Work Smarter Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Group and Outline

The Group command is a flexible way to show or hide rows or columns. It is similar to using Subtotals.

 

Try it: Group some rows of data

Before you begin, make a copy of the Original Data worksheet and rename it 2007 Sales Group.

 

Select of all the rows for February.

 

Now, go to the Data tab

Choose Group

 

Look of the left side of the screen for the Outline.

Data -> Group