software

Hi,

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

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

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

See quot;About using outlinesquot; in XL Help.The quot; quot; in the first formula is superfluous. It's often used by Lotus
users who have switched to XL.In article gt;,
quot;marioquot; gt; wrote:

gt; Hi,
gt;
gt; I received a excel file, where there is quot; quot; sign on the left. If I click it,
gt; it expands and click it again collapses. What is that for?
gt;
gt; Also I see quot;1quot;, quot;2quot; on the top left. If i click quot;1quot; all the quot; quot; expand and
gt; if I click quot;2quot; all of them collapse.
gt;
gt; What is the difference in these two formulas:
gt; = A32 A31
gt; =A32 A31


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 Datagt;Subtotals

Dave
mario Wrote:
gt; Hi,
gt;
gt; I received a excel file, where there is quot; quot; sign on the left. If I
gt; click it,
gt; it expands and click it again collapses. What is that for?
gt;
gt; Also I see quot;1quot;, quot;2quot; on the top left. If i click quot;1quot; all the quot; quot; expand
gt; and
gt; if I click quot;2quot; all of them collapse.
gt;
gt; What is the difference in these two formulas:
gt; = A32 A31
gt; =A32 A31--
Desert Piranha------------------------------------------------------------------------
Desert Piranha's Profile: www.excelforum.com/member.php...oamp;userid=28934
View this thread: www.excelforum.com/showthread...hreadid=514276