how do i expand and collapse rows


O

office wreck!

I need to expand and collapse ROWS, I want main info seen and rows below it
collapsed so I can expand as needed, How do i do that?? i keep trying but
it's not working out very well!
 
Ad

Advertisements

D

DJH6064

This is just what the subtotals command can be used for. If your data is in a
list, yiou can use the subtotals command to insert subtotals based on groups
of data. You can expand or collaps the data groups that you want. The
command is located on the Data menu in 2003 and the Data tab in 2007.
 
A

AltaEgo

Yes, that might also be what the OP sought. The main point here would be to
uncheck the "summary data below" option to show data below the summary.
 
O

office wreck!

Alta - YOU ROCK That is exactly what i needed!! thanks so much. my brain
fart lasted a lot longer than i thought, been a while since i needed to use
that function, thanks so much!
 
Ad

Advertisements

J

jakkory

Alta - YOU ROCK That is exactly what i needed!! thanks so
much. my brain fart lasted a lot longer than i thought, been a
while since i needed to use that function, thanks so much!

Now that's a satisfied customer! :)
 
Ad

Advertisements

S

Shane Devenshire

Hi,

This is also what pivot table often do and they are much more powerful and
flexible than the Data, Subtotal command once you learn them. For example to
expand and collapse the data under a particular category just double click
the category row and all the detail is shown or hidden.
 

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