ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to get my total back? (https://www.excelbanter.com/excel-worksheet-functions/226080-how-get-my-total-back.html)

Earleb

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

T. Valko

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




Meebers[_2_]

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






T. Valko

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








T. Valko

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









Earleb

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








Meebers[_2_]

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









T. Valko

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










Meebers[_2_]

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










T. Valko

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













All times are GMT +1. The time now is 12:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com