View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Umlas Bob Umlas is offline
external usenet poster
 
Posts: 301
Default How do you create roll-up rows in EXCEL?

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


"TOMA" wrote in message
...
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?