Faster way to fill down, when blanks in rows exist

  • Thread starter Thread starter Mike C
  • Start date Start date
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.
 
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
 
Back
Top