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?

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.
--

_______________________
Naz,
London


"DUCDB" wrote:

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?

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?

"Naz" wrote:

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.
--

_______________________
Naz,
London


"DUCDB" wrote:

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?

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, ViewStatus Bar to enable.


Gord Dibben Excel MVP


On Mon, 31 Oct 2005 10:09:34 -0800, "DUCDB"
wrote:

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?

"Naz" wrote:

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.
--

_______________________
Naz,
London


"DUCDB" wrote:

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?

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.


"DUCDB" wrote:

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?