| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get my total back?
I am using Excel 2007. I used to be able to move my mouse over several cells
(containing numerals), with the resulting total being shown in a cell on the horizontal bar at the bottom of my chart sheet. I inadvertently messed that up and am not able to get the total back. Please help me with this issue. Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get my total back?
the horizontal bar at the bottom of my chart sheet.
That's called the status bar. Hover your mouse in the status bar. Right click and you'll be presented with a bunch of options. Choose the ones you want. -- Biff Microsoft Excel MVP "Earleb" wrote in message ... I am using Excel 2007. I used to be able to move my mouse over several cells (containing numerals), with the resulting total being shown in a cell on the horizontal bar at the bottom of my chart sheet. I inadvertently messed that up and am not able to get the total back. Please help me with this issue. Thank you |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get my total back?
Not to steal the thread, but...how do you turn on or off the options. The
only ones showing are the micro, zoom and zoom slider. While others are "checked" & unchecked, nothing happens, they do not show. "T. Valko" wrote in message ... the horizontal bar at the bottom of my chart sheet. That's called the status bar. Hover your mouse in the status bar. Right click and you'll be presented with a bunch of options. Choose the ones you want. -- Biff Microsoft Excel MVP "Earleb" wrote in message ... I am using Excel 2007. I used to be able to move my mouse over several cells (containing numerals), with the resulting total being shown in a cell on the horizontal bar at the bottom of my chart sheet. I inadvertently messed that up and am not able to get the total back. Please help me with this issue. Thank you |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get my total back?
how do you turn on or off the options.
Click on them with your mouse. That'll toggle them either on or off. When they're on a checkmark appears by the item. -- Biff Microsoft Excel MVP "Meebers" wrote in message ... Not to steal the thread, but...how do you turn on or off the options. The only ones showing are the micro, zoom and zoom slider. While others are "checked" & unchecked, nothing happens, they do not show. "T. Valko" wrote in message ... the horizontal bar at the bottom of my chart sheet. That's called the status bar. Hover your mouse in the status bar. Right click and you'll be presented with a bunch of options. Choose the ones you want. -- Biff Microsoft Excel MVP "Earleb" wrote in message ... I am using Excel 2007. I used to be able to move my mouse over several cells (containing numerals), with the resulting total being shown in a cell on the horizontal bar at the bottom of my chart sheet. I inadvertently messed that up and am not able to get the total back. Please help me with this issue. Thank you |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get my total back?
P.S.
The math operations only show up, if they're turned on, when you select a *range* of cells. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... how do you turn on or off the options. Click on them with your mouse. That'll toggle them either on or off. When they're on a checkmark appears by the item. -- Biff Microsoft Excel MVP "Meebers" wrote in message ... Not to steal the thread, but...how do you turn on or off the options. The only ones showing are the micro, zoom and zoom slider. While others are "checked" & unchecked, nothing happens, they do not show. "T. Valko" wrote in message ... the horizontal bar at the bottom of my chart sheet. That's called the status bar. Hover your mouse in the status bar. Right click and you'll be presented with a bunch of options. Choose the ones you want. -- Biff Microsoft Excel MVP "Earleb" wrote in message ... I am using Excel 2007. I used to be able to move my mouse over several cells (containing numerals), with the resulting total being shown in a cell on the horizontal bar at the bottom of my chart sheet. I inadvertently messed that up and am not able to get the total back. Please help me with this issue. Thank you |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get my total back?
"T. Valko" wrote: how do you turn on or off the options. Click on them with your mouse. That'll toggle them either on or off. When they're on a checkmark appears by the item. Good stuff T. Valko... Where were you when I spent three frustrating hours worling on this. Regards -- Biff Microsoft Excel MVP "Meebers" wrote in message ... Not to steal the thread, but...how do you turn on or off the options. The only ones showing are the micro, zoom and zoom slider. While others are "checked" & unchecked, nothing happens, they do not show. "T. Valko" wrote in message ... the horizontal bar at the bottom of my chart sheet. That's called the status bar. Hover your mouse in the status bar. Right click and you'll be presented with a bunch of options. Choose the ones you want. -- Biff Microsoft Excel MVP "Earleb" wrote in message ... I am using Excel 2007. I used to be able to move my mouse over several cells (containing numerals), with the resulting total being shown in a cell on the horizontal bar at the bottom of my chart sheet. I inadvertently messed that up and am not able to get the total back. Please help me with this issue. Thank you |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get my total back?
Well...thats exactly what I was doing. Click them with my mouse, the check
mark appears but nothing shows up in the bottom task bar. i.e. looking at "SUM" there is not an On/Off indicator to the right whenever a click a check mark or not. Contrary, "Caps Lock" is always OFF even though I toggle the check mark on or off. It seems simple on how I think it should work, click a item, the check mark appears, the item appears on the bottom task bar, no joy for me. "T. Valko" wrote in message ... how do you turn on or off the options. Click on them with your mouse. That'll toggle them either on or off. When they're on a checkmark appears by the item. -- Biff Microsoft Excel MVP "Meebers" wrote in message ... Not to steal the thread, but...how do you turn on or off the options. The only ones showing are the micro, zoom and zoom slider. While others are "checked" & unchecked, nothing happens, they do not show. "T. Valko" wrote in message ... the horizontal bar at the bottom of my chart sheet. That's called the status bar. Hover your mouse in the status bar. Right click and you'll be presented with a bunch of options. Choose the ones you want. -- Biff Microsoft Excel MVP "Earleb" wrote in message ... I am using Excel 2007. I used to be able to move my mouse over several cells (containing numerals), with the resulting total being shown in a cell on the horizontal bar at the bottom of my chart sheet. I inadvertently messed that up and am not able to get the total back. Please help me with this issue. Thank you |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get my total back?
Where were you when I spent three frustrating hours worling on this.
I was just sitting here bored out of my mind looking for something to do. <g Thanks for the feedback! -- Biff Microsoft Excel MVP "Earleb" wrote in message ... "T. Valko" wrote: how do you turn on or off the options. Click on them with your mouse. That'll toggle them either on or off. When they're on a checkmark appears by the item. Good stuff T. Valko... Where were you when I spent three frustrating hours worling on this. Regards -- Biff Microsoft Excel MVP "Meebers" wrote in message ... Not to steal the thread, but...how do you turn on or off the options. The only ones showing are the micro, zoom and zoom slider. While others are "checked" & unchecked, nothing happens, they do not show. "T. Valko" wrote in message ... the horizontal bar at the bottom of my chart sheet. That's called the status bar. Hover your mouse in the status bar. Right click and you'll be presented with a bunch of options. Choose the ones you want. -- Biff Microsoft Excel MVP "Earleb" wrote in message ... I am using Excel 2007. I used to be able to move my mouse over several cells (containing numerals), with the resulting total being shown in a cell on the horizontal bar at the bottom of my chart sheet. I inadvertently messed that up and am not able to get the total back. Please help me with this issue. Thank you |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get my total back?
OK...drank a beer..now I see how it works......
"Earleb" wrote in message ... "T. Valko" wrote: how do you turn on or off the options. Click on them with your mouse. That'll toggle them either on or off. When they're on a checkmark appears by the item. Good stuff T. Valko... Where were you when I spent three frustrating hours worling on this. Regards -- Biff Microsoft Excel MVP "Meebers" wrote in message ... Not to steal the thread, but...how do you turn on or off the options. The only ones showing are the micro, zoom and zoom slider. While others are "checked" & unchecked, nothing happens, they do not show. "T. Valko" wrote in message ... the horizontal bar at the bottom of my chart sheet. That's called the status bar. Hover your mouse in the status bar. Right click and you'll be presented with a bunch of options. Choose the ones you want. -- Biff Microsoft Excel MVP "Earleb" wrote in message ... I am using Excel 2007. I used to be able to move my mouse over several cells (containing numerals), with the resulting total being shown in a cell on the horizontal bar at the bottom of my chart sheet. I inadvertently messed that up and am not able to get the total back. Please help me with this issue. Thank you |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get my total back?
Good deal. Now it's my turn to have a cold 1 (or 2, or 3, or...)
-- Biff Microsoft Excel MVP "Meebers" wrote in message ... OK...drank a beer..now I see how it works...... "Earleb" wrote in message ... "T. Valko" wrote: how do you turn on or off the options. Click on them with your mouse. That'll toggle them either on or off. When they're on a checkmark appears by the item. Good stuff T. Valko... Where were you when I spent three frustrating hours worling on this. Regards -- Biff Microsoft Excel MVP "Meebers" wrote in message ... Not to steal the thread, but...how do you turn on or off the options. The only ones showing are the micro, zoom and zoom slider. While others are "checked" & unchecked, nothing happens, they do not show. "T. Valko" wrote in message ... the horizontal bar at the bottom of my chart sheet. That's called the status bar. Hover your mouse in the status bar. Right click and you'll be presented with a bunch of options. Choose the ones you want. -- Biff Microsoft Excel MVP "Earleb" wrote in message ... I am using Excel 2007. I used to be able to move my mouse over several cells (containing numerals), with the resulting total being shown in a cell on the horizontal bar at the bottom of my chart sheet. I inadvertently messed that up and am not able to get the total back. Please help me with this issue. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
| How do I change a file from read only back to total access? | New Users to Excel | |||
| Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
| copy back macro/roll back | Excel Worksheet Functions | |||
| Total back to w/c Monday | Excel Worksheet Functions | |||
Linear Mode
