How do you create roll-up rows in EXCEL?

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to roll up columns or rows for summary purposes? 1
How do I hide multiple rows under one row IN EXCEL? 2
Hidden text in tables causes empty rows 0
Inserting and Deleting Rows in Excel 2
Delete only Filetered rows in excel 2007 not hidden rows or header 0
Excel - viewing hidden rows 2
Automatically hide/unhide rows 5
How to change the number of rows in a worksheet. 2

Top