To turn off the Auto Sum feature in Microsoft Excel, you can follow these steps:

1. Click on the "Formulas" tab in the ribbon at the top of the Excel window.
2. In the "Function Library" group, click on the "AutoSum" dropdown button.
3. Click on "AutoSum" again to uncheck it and turn off the feature.

Alternatively, you can also use the keyboard shortcut "Alt + =" to toggle the Auto Sum feature on and off.

It's important to note that turning off Auto Sum will only affect the current worksheet. If you want to turn off Auto Sum for all new workbooks, you can go to the Excel Options menu, select "Formulas" in the left-hand menu, and uncheck the "AutoSum" box under the "Working with formulas" section.

Right click toolbar
Click "Customize"
Drag the AutoSum tool off the bar
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"JY" wrote in message
...

More detail please.


Gord Dibben MS Excel MVP

On Fri, 9 Feb 2007 09:02:00 -0800, JY wrote:

Sounds reasonable<g

Gord

On Fri, 9 Feb 2007 14:27:20 -0400, "Bernard Liengme"
wrote:

Right click toolbar
Click "Customize"
Drag the AutoSum tool off the bar
best wishes