how do i expand and collapse rows

  • Thread starter Thread starter office wreck!
  • Start date Start date
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!
 
 
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.
 
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.
 
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!
 
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!
Click to expand...

Now that's a satisfied customer! :-)
 
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.
 
Back
Top