Mouse controlled auto sum feature lost

  • Thread starter Lost is Allentown
  • Start date
L

Lost is Allentown

HELP!
I used to be able to use my mouse to highlight a range of cells in Excel and
have the sum, min, max, avg, etc displayed at the bottom of the spreadsheet
in what looked like a gray toolbar that was below the tabs of the spreadsheet
and contained the word 'Ready'. Somehow I lost the ability to do this. Is
this an Option, Toolbar, or what that I need to turn on to activate this
feature again?
 
N

Niek Otten

Right-click in that bar and you'll get a choice

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| HELP!
| I used to be able to use my mouse to highlight a range of cells in Excel and
| have the sum, min, max, avg, etc displayed at the bottom of the spreadsheet
| in what looked like a gray toolbar that was below the tabs of the spreadsheet
| and contained the word 'Ready'. Somehow I lost the ability to do this. Is
| this an Option, Toolbar, or what that I need to turn on to activate this
| feature again?
|
|
 
L

Lost is Allentown

The bar isn't there. There is nothing below the tabs of the workbook. How
do I get the bar?
 
K

KLZA

Right-click in that bar and you'll get a choice

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| HELP!
| I used to be able to use my mouse to highlight a range of cells in Excel and
| have the sum, min, max, avg, etc displayed at the bottom of the spreadsheet
| in what looked like a gray toolbar that was below the tabs of the spreadsheet
| and contained the word 'Ready'. Somehow I lost the ability to do this. Is
| this an Option, Toolbar, or what that I need to turn on to activate this
| feature again?
|
|
Click to expand...

Make sure you have your status bar enabled. Go to view > status
bar. :)
 
K

KLZA

The bar isn't there. There is nothing below the tabs of the workbook. How
do I get the bar?







- Show quoted text -
Click to expand...

Go to View > Status Bar. Once enabled, you can right-click and you
get the following options: AVG, COUNT, COUNT NUMS, MAX, MIN, and of
course SUM. :)
 
L

Lost is Allentown

The Status bar is enabled. I on checked a co-worker's workstation who has
the bar and notice that the bar is 'below' the tabs of the workbook. My
spreadsheet ends with the tabs, I don't have that extra gray bar below the
tabs, yet the status bar is enabled.
 
G

Gord Dibben

The gray bar is the "Status Bar" and if you right-click on it you will get the
list of options.


Gord Dibben MS Excel MVP


On Wed, 1 Aug 2007 12:40:00 -0700, Lost is Allentown <Lost is
 
Top