Can Excel Handle Dragging Formulas for 64K Rows?

2 replies · 10K views · last reply
Science Advisor
Homework Helper
Messages
7,906
Reaction score
15
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?
 
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.