Mouse controlled auto sum feature lost

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
|
|
 
The bar isn't there. There is nothing below the tabs of the workbook. How
do I get the bar?
 
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. :)
 
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. :)
 
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum after Filter, Count after Fliter 2
Drag Mouse and Add-up 1
auto SUM bottom page 2
SUM TOTALS AT BOTTOM OF WORKSHEET 2
Sum box at bottom toolbar of Excel 4
Sum Function 3
Missing sum bottom of excel window 9
auto sum feature 2

Back
Top