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
|