Results 1 to 5 of 5
  1. #1
    Bronze Lounger DrWho's Avatar
    Join Date
    Dec 2009
    Location
    Central Florida
    Posts
    1,501
    Thanks
    30
    Thanked 205 Times in 163 Posts

    Cool Extending formulas down a spreadsheet

    I have an Excel 2007 spreadsheet that I use for calculating MPG, cost per mile driven, etc.

    I got the spreadsheet from an Internet source and it came with several columns with Formulas in them.
    But the formulas only extend down the sheet to line 50, then they stop.

    What I need to know is how to extend the formulas in their columns down to say line 200 or more.

    I have no formal or otherwise training in Excel, so this has become a real problem for me as I approach line 50.

    In the past I've just closed the sheet when line 50 is reached and I start a new sheet. I'd like to NOT have to do that when the sheet gets full again.

    Any help will be greatly appreciated.


    Thank you,
    Experience is truly the best teacher.

    Backup! Backup! Backup! GHOST Rocks!

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    Just highlight/copy the last line of cell(s), highlight same range of cells in rows 51-200 and then paste. Any adjustments in the formulas will be made automatically.

    HTH,
    Maud

    PS Haven't crossed the Doctor's path in quite a while!
    Last edited by Maudibe; 2013-01-16 at 15:51. Reason: spelling

  3. The Following User Says Thank You to Maudibe For This Useful Post:

    DrWho (2013-01-17)

  4. #3
    Star Lounger
    Join Date
    Oct 2012
    Posts
    55
    Thanks
    1
    Thanked 10 Times in 10 Posts
    Hi

    Just to add to Maudibe post, ensure that the cell referencing is correct.

  5. #4
    Bronze Lounger DrWho's Avatar
    Join Date
    Dec 2009
    Location
    Central Florida
    Posts
    1,501
    Thanks
    30
    Thanked 205 Times in 163 Posts
    Maudibe,
    Thank you very much!
    My accomplishments in this world are many and varied, but I must admit that programming Excel is definitely NOT one of them.
    So your answer to my query was Right ON and very helpful.

    I did make a few false starts, before I got it right. Your explanation was very straight forward and 100% correct, but there's a little "Technique" in there that has to be mastered before total success comes. (I practiced on an old retired spreadsheet before I actually worked the magic on my current MPG spreadsheet) Better safe than sorry, , , Eh?

    But now, Thank YOU, I have my formulas extended down to line 250. That should easily carry me through to the end of the year, when I'll retire the current spreadsheet and start a new one for 2014.

    Just for fun, here's a few lines from that Excel spreadsheet.


    It sure beats keeping my mileage and gasoline purchases in a written journal and doing all the math by hand.

    Thanks again!

    The Doctor
    Last edited by DrWho; 2013-01-18 at 09:22.
    Experience is truly the best teacher.

    Backup! Backup! Backup! GHOST Rocks!

  6. The Following User Says Thank You to DrWho For This Useful Post:

    Maudibe (2013-01-19)

  7. #5
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    More than welcome Doc! Thanks for the follow up and sample.

    Maud

  8. The Following User Says Thank You to Maudibe For This Useful Post:

    DrWho (2013-01-19)

Posting Permissions

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