View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
AltaEgo AltaEgo is offline
external usenet poster
 
Posts: 245
Default how do i expand and collapse rows

Two options come to mind:

1) You can hide rows

XL2003
http://office.microsoft.com/en-us/ex...CH062527931033

XL2007
http://office.microsoft.com/en-us/ex...CH100648381033

2) You can set a freeze pane so, as you scroll down, you continue to see
headings at the top of the page

XL2003
http://office.microsoft.com/en-us/ex...33#FreezePanes

XL2007
http://office.microsoft.com/en-us/ex...33#FreezePanes


--
Steve

"office wreck!" <office wrote in message
...
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!