Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JY JY is offline
external usenet poster
 
Posts: 4
Default Auto Sum, how do you turn it off??


  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,393
Default 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
...



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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:


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I turn on Auto Filter?? It is grayed out. Ray Excel Discussion (Misc queries) 4 March 18th 09 08:02 PM
How to turn off auto update on a formula Dave Excel Discussion (Misc queries) 0 February 20th 06 10:15 PM
how do I turn ON auto REcalculate for formulas if new data enter? Mark Excel Worksheet Functions 1 January 19th 06 04:19 AM
How do you turn off pivot table auto format in Excel? srudd Excel Discussion (Misc queries) 3 November 30th 05 05:35 AM
How can I turn auto correct on or off for one column only? jacskier Excel Worksheet Functions 3 June 13th 05 04:55 PM


All times are GMT +1. The time now is 04:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"