Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Dragging formula in Excel

  1. Sep 27, 2007 #1

    mgb_phys

    User Avatar
    Science Advisor
    Homework Helper

    Now that excel handles 64K of rows it is becoming a pain dragging a formula to fill in that many rows.
    Is there a way of selecting a range and having the formula drag apply to that range?
     
  2. jcsd
  3. Sep 28, 2007 #2

    Dr Transport

    User Avatar
    Science Advisor
    Gold Member

    copy the formula, then highlight the cells/rows you want then paste. You shouldn't have to drag.
     
  4. Sep 29, 2007 #3

    mgb_phys

    User Avatar
    Science Advisor
    Homework Helper

    Thanks, that was obvious - I hadn't tried it because I was thinking of ranges where you have to drag to automatically increment the range.
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?



Similar Discussions: Dragging formula in Excel
  1. Excel + Calculations (Replies: 9)

Loading...