Sum box at bottom toolbar of Excel

[Guest]

I used to have a box in the bottom toolbar of my Excel spreadsheets that
automatically summed any cells selected on the worksheet. How do I turn that
feature on/off?

 

[Guest]

Autocalc
In the bottom right hover over where it use to be, just over NUM will do as
well, and right click a little menu appears with sum, average count etc it
may have become set to none. Simply select Sum.

 

[Guest]

Thanks for the response. The NUM feature is no longer present on the
worksheet toolbar, that's the problem. Where do I turn it on/off?

 

[Gord Dibben]

What you are calling the worksheet toolbar is known as the "status bar".

NUM will appear when NumLock is enabled.

The Sum will appear when you have right-clicked on the status bar and selected
from the list of options........count, average, min, max, sum, count nums.

If you have no status bar to right-click, View>Status Bar to enable.


Gord Dibben Excel MVP

 

[Guest]

The NUM feature isn't a feature......its Excel place for showing you that the
Numlock key on the keypad has been activated so you can use the keypad( check
your keypad above 7), and you would get CAPS if you pressed the Caps Lock
key..and so on for Scroll lock.

But if you right click in that region the menu will pop up.

The two although appear close are defferent things. I was simply using the
NUM location to guide to to whereabout to right click.

Hope that clarifies.