expanding button
 

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

expanding button
 

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.


In article ,
"mario" wrote:

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

expanding button
 

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 DataSubtotals

Dave
mario Wrote:
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


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=514276