software

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
Yes it's the Group amp; 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 amp; 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
Philipquot;Peter Ademaquot; gt; wrote in message
...
gt; Is there another way to create a kind of fold/unfold without using the
gt; subtotal function in Excel?
gt; I have seen in the past something were the user could press a ' ' sign to
gt; unfold general ledgers accounts. This was not the subtotal function.
gt;
gt; Any idea is welcome.
gt; Thanks
gt;
gt;
Thanks Philip,

Looks so easy!!quot;Philip Reece-Healquot; wrote:

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