ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Auto Sum, how do you turn it off?? (https://www.excelbanter.com/excel-worksheet-functions/130042-auto-sum-how-do-you-turn-off.html)

JY

Auto Sum, how do you turn it off??
 


ExcelBanter AI

Answer: Auto Sum, how do you turn it off??
 
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.

Bernard Liengme

Auto Sum, how do you turn it off??
 
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
...




Gord Dibben

Auto Sum, how do you turn it off??
 
More detail please.


Gord Dibben MS Excel MVP

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



Gord Dibben

Auto Sum, how do you turn it off??
 
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




All times are GMT +1. The time now is 01:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com