Collapsing Rows

E

EdCPA

I have seen spreadsheets where rows are subtotaled and the rows making up the
subtotaled are hidden. In other words, rows are expanded and then the detail
is closed.

My question is how do I set up my spread sheet to expand and collapse?

I would appreciate any help.
 
D

Dave Peterson

Sort your data by some key column.
Then select your range and do
Data|subtotals
Use at each change in that key column to
count/sum/average....
for every field you want.

You'll see those outlining symbols to the left. You can expand/hide by clicking
on those numbers at the top or by clicking on the +/-'s for each level.

=====
You can also get them via data|Group.
 

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

Top