Faster way to fill down, when blanks in rows exist

M

Mike C

Is there possibly a faster way to fill down (e.g., drag a formula from
row 1 to fill all the way through row 33,000) , when there are blanks
in the rows throughout the data.

It takes forever to drag it down to the bottom of row 33,000.

Is there a better way to accomplish this?

Thanks for any suggestions.
 
G

Gord Dibben

Enter your formula in a cell, say B1

In namebox enter B1:B33000 and ENTER

CTRL + d to fill down


Gord Dibben MS Excel MVP
 
Top