How do you create roll-up rows in EXCEL?

T

TOMA

I have recently seen a worksheet with + boxes to the left of a row that when
you click on it several related rows are revealed and the + becomes a -. When
you click the - the newly reveald rows are hidden and the initial line is
visible and the sign chaned back to a +.

Can someone tell me how this is done?
 
B

Bob Umlas

By Grouping. Excel 2003: Select the rows (or columns) you want to group,
then use Data/Group and Outline/Group. in Excel 2007: Data tab/Group
Bob Umlas
Excel MVP
 
Top