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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to fill down automatically the number of rows in a spreadsheet 1
Fill rows with column information 2
numbering rows, but skipping blanks 13
Removing blank rows 2
fill all row cells with double click 3
Fill cells increment row number i fomula 1
Drag down to fill in, but copy, not increment? 10
Offset and Small functions with blank rows? 0

Back
Top