Fold / unfold without subtotals function

[Peter Adema]

Is there another way to create a kind of fold/unfold without using the
subtotal function in Excel?
I have seen in the past something were the user could press a '+' sign to
unfold general ledgers accounts. This was not the subtotal function.

Any idea is welcome.
Thanks

[Philip Reece-Heal]

Yes it's the Group & Outline option on the Data menu.

Ie if you want to apply it to a column (or range of adjacent columns) select
it/them, Click Data menu then Group & Outline, then click Group and select
Columns.

You will get the little plus sign at the top of the worksheet and you can
click it to open/close that range

Hope that helps
Philip


"Peter Adema" <[email protected]> wrote in message
news:[email protected]...
> Is there another way to create a kind of fold/unfold without using the
> subtotal function in Excel?
> I have seen in the past something were the user could press a '+' sign to
> unfold general ledgers accounts. This was not the subtotal function.
>
> Any idea is welcome.
> Thanks
>
>

[Peter Adema]

Thanks Philip,

Looks so easy!!


"Philip Reece-Heal" wrote:

> Yes it's the Group & Outline option on the Data menu.
>
> Ie if you want to apply it to a column (or range of adjacent columns) select
> it/them, Click Data menu then Group & Outline, then click Group and select
> Columns.
>
> You will get the little plus sign at the top of the worksheet and you can
> click it to open/close that range
>
> Hope that helps
> Philip
>
>
> "Peter Adema" <[email protected]> wrote in message
> news:[email protected]...
> > Is there another way to create a kind of fold/unfold without using the
> > subtotal function in Excel?
> > I have seen in the past something were the user could press a '+' sign to
> > unfold general ledgers accounts. This was not the subtotal function.
> >
> > Any idea is welcome.
> > Thanks
> >
> >
>
>
>