Jack-P-Winner
Member
I have to drag a formula down almost 750,000 rows. Is there a quick way to drag it down to the bottom?
How can I speed up excel when I drag a formula down?
- Thread starter Jack-P-Winner
- Start date
Why use the mouse? Use the keyboard instead. Go to the nearest column that has continuous data. Use the Ctrl+ArrowDown to get to the bottom. Move over to where the new formula needs to be. Anchor the point by holding down the shift key and then Ctrl+ArrowUP. Ctrl+D to copy down and you are done.