Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mouse controlled auto sum feature lost
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mouse controlled auto sum feature lost
Right-click in that bar and you'll get a choice
-- Kind regards, Niek Otten Microsoft MVP - Excel "Lost is Allentown" <Lost is wrote in message ... | 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? | | |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mouse controlled auto sum feature lost
The bar isn't there. There is nothing below the tabs of the workbook. How
do I get the bar? "Niek Otten" wrote: Right-click in that bar and you'll get a choice -- Kind regards, Niek Otten Microsoft MVP - Excel "Lost is Allentown" <Lost is wrote in message ... | 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? | | |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mouse controlled auto sum feature lost
On Aug 1, 3:45 pm, "Niek Otten" wrote:
Right-click in that bar and you'll get a choice -- Kind regards, Niek Otten Microsoft MVP - Excel "Lost is Allentown" <Lost is wrote in ... | 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? | | Make sure you have your status bar enabled. Go to view status bar. :) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mouse controlled auto sum feature lost
On Aug 1, 3:54 pm, Lost is Allentown
wrote: The bar isn't there. There is nothing below the tabs of the workbook. How do I get the bar? "Niek Otten" wrote: Right-click in that bar and you'll get a choice -- Kind regards, Niek Otten Microsoft MVP - Excel "Lost is Allentown" <Lost is wrote in message ... | 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? | |- Hide quoted text - - Show quoted text - 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. :) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mouse controlled auto sum feature lost
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. "KLZA" wrote: On Aug 1, 3:54 pm, Lost is Allentown wrote: The bar isn't there. There is nothing below the tabs of the workbook. How do I get the bar? "Niek Otten" wrote: Right-click in that bar and you'll get a choice -- Kind regards, Niek Otten Microsoft MVP - Excel "Lost is Allentown" <Lost is wrote in message ... | 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? | |- Hide quoted text - - Show quoted text - 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. :) |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mouse controlled auto sum feature lost
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 wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto save feature in excel | Excel Worksheet Functions | |||
Excel's 2003 Auto Recover Feature | Excel Discussion (Misc queries) | |||
Menus / Links associated with right-mouse-click lost! | Excel Discussion (Misc queries) | |||
where can I find the Auto Sum feature on Excel | Excel Worksheet Functions | |||
How do I disable the auto hyperlink feature in Excel? | Excel Discussion (Misc queries) |