Need help to make collapsing section in Microsoft Excel

[Jaques Strapp]

I wouldd 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.

[BillieJ]

Go in Microsoft Excel 2003 menus and Select the rows to group. For that click on Data > Group and outline > group. Use data|Group and outline|settings if you want the "button" on the top or might be at the 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.

[JustineBB]

Select the rows/columns which you want to use as collapsing menu click Data > Group and Outline > Group/Ungroup. Another thing you can try is Choose the Row or Column range and from group :

<Shift> <Alt> <RightArrow>
To ungroup,
<Shift> <Alt> <LeftArrow>

To retain the Groups, but toggle hide/unhide the symbols - Ctrl> <8>
Using the 8 that's under the function keys, not from the num keypad.