How to get my total back?

[Earleb]

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]

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.

 

[Meebers]

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]

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.

 

[T. Valko]

P.S.

The math operations only show up, if they're turned on, when you select a
*range* of cells.

 

[Earleb]

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

 

[Meebers]

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]

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!

 

[Meebers]

OK...drank a beer..now I see how it works......

Good stuff T. Valko...
Where were you when I spent three frustrating hours worling on this.

Regards

 

[T. Valko]

Good deal. Now it's my turn to have a cold 1 (or 2, or 3, or...)