Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Minnesota, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Inserted rows and missing formulas (Excel 2000 SR-1)

    There have been times when I have inserted a row in the middle of a sheet (e.g., a budget, for example) and the inserted row automatically copied formulas from the prior row. Other times, when I insert the row, the formulas are not copied and must be manually copied down to the cells in the new row. I have never been able to figure out what I'm doing differently, or why that happens. It's just one of those nagging annoyances. Anyone able to give me a clue? Thanks for any suggestions.
    Karnie Moesenthin
    Technical Training and Development Professional
    Legal Industry

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Inserted rows and missing formulas (Excel 2000 SR-1)

    See if XL2000: How Auto Extend List Behavior Works satisfies your curiosity.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Minnesota, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inserted rows and missing formulas (Excel 2000 SR-1)

    I think it will, Hans. I'll have to try out some of the examples given in the article. I didn't know the correct term to search for. As always, I appreciate the quick response. Thank you.
    Karnie Moesenthin
    Technical Training and Development Professional
    Legal Industry

Posting Permissions

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