Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insert cells with previous formulas? (Excel 2000 )

    Let's say I've got a spreadsheet with values in Column A, values in Column B, and a formula in C that adds columns A & B together. This goes about 20 rows down the page. If I attempt to insert a new row above column 14, a new row is inserted with no problem, but the formula that should reside in Column C does not automatically get entered. You have to copy/paste from the cell above it. Is there a way to insert a row with the formulas used in the previous/next cell? If not, any idea why this would not be an option (because I feel sure that I'll have to explain the "Why not?" part of it to the user who asked).

  2. #2
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert cells with previous formulas? (Excel 2000 )

    OK - may have answered my own question. If you have the Extend List Formats and Formulas option turned on (under Tools | Options | Edit tab), then when you insert a new row, even though Column C does not appear to have a formula in it, once you enter values into columns A and B, the formula will continue in column C. Thanks for letting me talk though it aloud! <img src=/S/bingo.gif border=0 alt=bingo width=15 height=22>

Posting Permissions

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