Expanding/Collapsing Rows?

J

Jake

Is there another way to collapse rows of information without using the 'Hide'
feature? I'm looking for an expading tree type view, such as you would find
in explorer.
 
D

Dave Peterson

Select some rows, then Data|Group

Or you could apply Data|Subtotals (and get the added benefit of subtotals!)
 

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

Create form with checkbox les that expand and collapse sections of the form? 0
Collapse/Expand Buttons in a Pivot Table 0
Expand/Collapse in Pivot Tables 2
Collapsing/expanding grouped areas on multiple pages 1
Automatically expanding outline section if values are present 1
Outline View: collapse 'up' to parent heading? 7
collapsing rows 5
How do I move the expand/collapse for rows and columns in Excel? 0

Top