| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto sum not working - how enable?
when select group of cells, in status bar (lower right corner) only displays
largest value in group. how do you enable auto sum or fix this problem? thanks for help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto sum not working - how enable?-IGNORE-answer: chg max to sum
"ALOTT5K" wrote: when select group of cells, in status bar (lower right corner) only displays largest value in group. how do you enable auto sum or fix this problem? thanks for help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto sum not working - how enable?
The number that appears on the right side of the status bar when one or more
value cells are selected can be a sum, an average, a max, a min, or a count. It sounds like yours is set to max. simply right click that portion of the status bar and a menu will appear from which you can select sum. "ALOTT5K" wrote: when select group of cells, in status bar (lower right corner) only displays largest value in group. how do you enable auto sum or fix this problem? thanks for help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I enable auto complete? | Excel Discussion (Misc queries) | |||
| How do I enable auto-expanding lists in a protected worksheet? | Excel Discussion (Misc queries) | |||
| How do you avoid window that prompts to enable auto query refresh | Excel Discussion (Misc queries) | |||
| Can you enable auto complete from a custom list in Excel? | Excel Discussion (Misc queries) | |||
| excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
Linear Mode
