Can Excel Handle Dragging Formulas for 64K Rows?

[mgb_phys]

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?

 

[Dr Transport]

copy the formula, then highlight the cells/rows you want then paste. You shouldn't have to drag.

 

[mgb_phys]

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.