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 :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=569145

Uzytkownik napisal w wiadomosci
ups.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


" 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.

Good afternoon Ron,

Is there any way to set up the Status Toolbar so that we can see BOTH Sum
and Avg at the same time? It would save me having to switch back and forth
from one to the other all the time...

Thanks,
Hugues



"Ron Coderre" wrote:

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


" 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.