View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Expand/Collapse Buttons for hidden rows or colums

In xl2003 menus:

Select the rows.
Data|Group and outline|group

And then:
Data|Group and outline|Settings
and uncheck "Summary rows below detail"

You can also get these outlining symbols by using Data|subtotal.



Vineet Anand wrote:

After I hide 5 rows, how can I place a '+' button above the first hidden
row, which when clicked, would unhide the subsequent 5 rows ? The button
would then revert to '-' and perform the reverse function when clicked.

I remember seeing it on a worksheet once; if I know the above, I guess
it would work the same for columns.

- Many Thanks


--

Dave Peterson