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

  • Thread starter Thread starter nomail1983
  • Start date Start date
N

nomail1983

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" o
any other option

oldchippy :
 
Uzytkownik said:
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.
Click to expand...
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
 
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
 
Back
Top