automatic total of selected cells

[MarlboroughT&C]

Usually if I select a column or row of cells, I can see the total at the
bottom of the worksheet - this seems to have disappeared. How do I get it
back? I know this is dead simple, but I can't find the answer in help.

 

[Gary''s Student]

The area is called the Status Bar. Right-click the Bar and select the
desired function to appear there.

 

[JE McGimpsey]

And if you're not seeing the status bar, choose Tools/Options/View, and
check the Status Bar checkbox.

 

[MarlboroughT&C]

Fantastic! I knew it would be something simple - thanks to you both.

 

[Gord Dibben]

In Excel-not-for-Mac simply View>Status Bar

No need to go through Tools>Options.


Gord

 

[JE McGimpsey]

Thanks, Gord -

Actually, that works in Excel-for-Mac, too. I forget that, though, since
I've gotten rid of the View menu in my normal configuration.

 

[Gord Dibben]

I get caught same way due to removing default stuff from Toolbars and Menus.