How to change "automax" to "autosum"? (probablyl wrong terminology)

Once upon a time, as I highlighted a column of numbers, I would see the
cumulative sum in the lower right-hand status bar. Now I see the
cumulative max instead. I vaguely remember playing with some option to
cause this change in behavior. But I cannot remember how to do that
now.

How to I change the behavior so that I see the cumulative sum again?

Also, what are these features ("cumulative sum" and "cumulative max")
called?

I have not been able to think of a suitable keywork to use with Excel
help. It appears that the term "autosum" refers to the feature of
inserting the =SUM(...) formula in a cell at the end of a selected
column or row by clicking on the sigma symbol on the toolbar. That is
not the feature I am looking for. I do not want to enter the
cumulative sum into any cell in the spreadsheet. I just was to see it
on the status bar.

I am using Office Excel 2003.

Hi there,

Just right click on the "Max" sum on the status bar and select "SUM" or any other option

oldchippy

Uzytkownik <nomail1983@hotmail.com> napisal w wiadomosci
news:1154977457.352417.30960@m79g2000cwm.googlegroups.com...
> Once upon a time, as I highlighted a column of numbers, I would see the
> cumulative sum in the lower right-hand status bar. Now I see the
> cumulative max instead. I vaguely remember playing with some option to
> cause this change in behavior. But I cannot remember how to do that
> now.
>
> How to I change the behavior so that I see the cumulative sum again?
>
> Also, what are these features ("cumulative sum" and "cumulative max")
> called?
>
> I have not been able to think of a suitable keywork to use with Excel
> help. It appears that the term "autosum" refers to the feature of
> inserting the =SUM(...) formula in a cell at the end of a selected
> column or row by clicking on the sigma symbol on the toolbar. That is
> not the feature I am looking for. I do not want to enter the
> cumulative sum into any cell in the spreadsheet. I just was to see it
> on the status bar.
>
> I am using Office Excel 2003.
>
rught click on this max and change to whatever you want
mcg

Try this:

Right-click on the Excel Status Bar (that's the bar containing the "Max="
formula.
Select "Sum" from the function list.....Done (hopefully).

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"nomail1983@hotmail.com" wrote:

> Once upon a time, as I highlighted a column of numbers, I would see the
> cumulative sum in the lower right-hand status bar. Now I see the
> cumulative max instead. I vaguely remember playing with some option to
> cause this change in behavior. But I cannot remember how to do that
> now.
>
> How to I change the behavior so that I see the cumulative sum again?
>
> Also, what are these features ("cumulative sum" and "cumulative max")
> called?
>
> I have not been able to think of a suitable keywork to use with Excel
> help. It appears that the term "autosum" refers to the feature of
> inserting the =SUM(...) formula in a cell at the end of a selected
> column or row by clicking on the sigma symbol on the toolbar. That is
> not the feature I am looking for. I do not want to enter the
> cumulative sum into any cell in the spreadsheet. I just was to see it
> on the status bar.
>
> I am using Office Excel 2003.
>
>

I wrote:
> How to I change the behavior so that I see the cumulative sum again?

Thanks to all who reminded about right-clicking on the status bar.