Using Fill Handle For Formula

[Dazzawm]

I am wondering how you get over this. If I have a formula starting in say K1 and it is using info starting in A1, how do I use the fill handle to fire it down to say row 5000 if column J is blank. Do I always have to drag it down? As normally if there is info in column J then I can double click it down to the bottom.

 

[Jonmo1]

You could go to the Name Box (left of formula bar) and type in
A1:A5000
Press Enter
Then Press CTRL + D

 

[Dazzawm]

You could go to the Name Box (left of formula bar) and type in
A1:A5000
Press Enter
Then Press CTRL + D

Cant seem to get that to work.

 

[Dazzawm]

^