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 How to create collapsible sections in Excel

In xl2003 menus, I can use:

Select the rows to group
Data|Group and outline|group

Use data|Group and outline|settings if you want the "button" on the top (or
bottom).

Another option would be to apply Data|Subtotals to your range. You'll get those
outlining symbols and even a subtotal row between each group.

Tess wrote:

Hello,
I'd like to be able to create collapsible sections in an Excel worksheet
(2003).
So a column would appear down the left-hand side which would have the
equivalent of + and - that could be clicked to expose/hide the rows within a
specified range.
Has anyone done that?
Thanks for any tips.


--

Dave Peterson