Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    May 2002
    Location
    Melbourne, Australia
    Posts
    269
    Thanks
    32
    Thanked 0 Times in 0 Posts

    Inserting rows and AutoSum (Excel 2002 SP3)

    I have a simple spreadsheet with a few rows of numbers in a column, say A1 to A5 with an AutoSum =SUM(A1:A5) in cell A6. I then insert a new row, so my AutoSum is now in cell A7, but it still reads =SUM(A1:A5). I seem to recall that Excel used to always automatically adjust the formula to take account of the inserted row ... am I dreaming?
    Your assistance would be greatly appreciated.

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inserting rows and AutoSum (Excel 2002 SP3)

    If your cursor was in A6 when you inserted, then the formula wouldn't be adjusted automatically to include A1:A6. Same way if you put your cursor in the first row, the formula will go to A2:A6. Is this maybe what you were doing? If you put the cursor in rows 2, 3, 4, or 5 (in your example), it would adjust the formula to A1:A6 automatically.

  3. #3
    3 Star Lounger
    Join Date
    May 2002
    Location
    Melbourne, Australia
    Posts
    269
    Thanks
    32
    Thanked 0 Times in 0 Posts

    Re: Inserting rows and AutoSum (Excel 2002 SP3)

    Of course I wanted another row at the end of the list, so I inserted the new row at A6.
    Thank you for your prompt assistance.

Posting Permissions

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