| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
On status bar, sum of selected cells doesn't automatically appear.
Excel 2003 -
when you use the auto filter - nomally the sum of cells selected automatically shows up on the bottom left hand side of the status bar - eg: 32 of 100 records found.. but this is not always the case when i open or start a new worksheet Can anyone tell me if there is a function to activeate this on my worksheet... thanx |
|
#2
|
|||
|
|||
|
On status bar, sum of selected cells doesn't automatically appear.
Debra Dalgleish explains why and offers some workarounds:
http://contextures.com/xlautofilter02.html#Count Chozzie wrote: Excel 2003 - when you use the auto filter - nomally the sum of cells selected automatically shows up on the bottom left hand side of the status bar - eg: 32 of 100 records found.. but this is not always the case when i open or start a new worksheet Can anyone tell me if there is a function to activeate this on my worksheet... thanx -- Dave Peterson |
|
#3
|
|||
|
|||
|
On status bar, sum of selected cells doesn't automatically appear.
Right click on status bar, and see is sum or some other function selected.
"Chozzie" wrote in message ... Excel 2003 - when you use the auto filter - nomally the sum of cells selected automatically shows up on the bottom left hand side of the status bar - eg: 32 of 100 records found.. but this is not always the case when i open or start a new worksheet Can anyone tell me if there is a function to activeate this on my worksheet... thanx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing the way Excel displays selected cells | Excel Discussion (Misc queries) | |||
| How to stop Excel from automatically selecting cells? | Excel Discussion (Misc queries) | |||
| Paste and automatically move cells | Excel Discussion (Misc queries) | |||
| automatically fill in a range of cells | Excel Discussion (Misc queries) | |||
| automatically PRINT only active cells? | Excel Discussion (Misc queries) | |||
Linear Mode
