+ Reply to Thread
Results 1 to 4 of 4

When do and don't formulas carry down when inserting a row?

  1. #1
    Registered User
    Join Date
    03-20-2012
    Location
    Richmond, VA
    MS-Off Ver
    Excel 2007
    Posts
    2

    When do and don't formulas carry down when inserting a row?

    It seems to me that in prior versions of Excel,when you would insert a row, that the formulas from the rows above and below the insert would automatically carry into the insert row. In Excel 2007, it appears that sometimes they do and sometimes they don't. I can't find any consistency to this that would point me in a direction of "enabling" this feature. I am tired of having to go back and double check to make sure the formulas carry into the inserted rows. Thanks for any help.

  2. #2
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: When do and don't formulas carry down when inserting a row?

    if you insert a row that 'expands' a range referenced from a formula, that formula will include the new row, it the new row is bellow or above, it will not automaticaly be included. same for inserting columns.
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

  3. #3
    Registered User
    Join Date
    03-20-2012
    Location
    Richmond, VA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: When do and don't formulas carry down when inserting a row?

    I have a spreadsheet (HUGE of course) that totals at the bottom of several columns. I am inserting in the middle of the sheet. If I understand what you are saying, it should automatically put the formulas in the insert row. Yes? Well, I am finding that sometimes it does and sometimes it doesn't. I am looking for the key to making it do it all the time.

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,072

    Re: When do and don't formulas carry down when inserting a row?

    I believe if you insert a row into a range that is formatted as a table, then it will automatically insert the formula. I would always define ranges as tables.
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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