+ Reply to Thread
Results 1 to 2 of 2

autosum in excel 2007

  1. #1
    Registered User
    Join Date
    11-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question autosum in excel 2007

    Hi
    Billy 27 here asking for help about autosum.
    I have recently noticed while using one of my templates for keeping records of one of my pastimes some thing that happens in some cells but not others.
    If I place an amount such as 12.00 in one cell then 12.00 in the next cell and then highlight the next cell and click autosum, the result 24.00 appears, which is what I would expect. However, in some cells further down the work sheet, if I do the same thing, ie enter 12.00 in one cell then 12.00 in the next cell and then highlight the next cell, the result, 24.00, appears without me clicking on autosum. How does this work and can I set my worksheet up so this happens in all the cells?
    Thanks to any one who can help me.
    Billy27

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: autosum in excel 2007

    Pressing the AutoSum Icon or Pressing the Alt+= will pick the nearest data range automatically.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2010 - Autosum crash
    By conor1992 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-23-2013, 06:36 AM
  2. [SOLVED] How to program the Autosum feature in Excel
    By torontoguy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-21-2012, 05:01 PM
  3. Change AutoSum Direction in Excel
    By e@london in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-15-2012, 06:55 AM
  4. How do i protect a worksheet in Excel and still use AutoSum?
    By Jonathan Newman in forum Excel General
    Replies: 1
    Last Post: 07-17-2006, 09:12 AM
  5. [SOLVED] How to make autosum update totals in excel
    By Miranda in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-02-2006, 02:15 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1