expanding button

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mario - 20 Feb 2006 04:58 GMT

Hi,

I received a excel file, where there is "+" sign on the left. If I click it,
it expands and click it again collapses. What is that for?

Also I see "1", "2" on the top left. If i click "1" all the "+" expand and
if I click "2" all of them collapse.

What is the difference in these two formulas:
=+A32+A31
=A32+A31

Reply to this Message

JE McGimpsey - 20 Feb 2006 05:02 GMT

See "About using outlines" in XL Help.

The "+" in the first formula is superfluous. It's often used by Lotus
users who have switched to XL.

> Hi,
>
[quoted text clipped - 7 lines]
> =+A32+A31
> =A32+A31

Reply to this Message

Desert Piranha - 20 Feb 2006 05:26 GMT

Hi mario,

As for the first part of your question.
It sounds like you are talking about subtotals.

To set this condition up, or to remove the condition.

Select the range and go to Data>Subtotals

Dave
mario Wrote:

> Hi,
>
[quoted text clipped - 9 lines]
> =+A32+A31
> =A32+A31

Signature

Desert Piranha

Reply to this Message