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
 

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
numbering rows, but skipping blanks 13
Fill rows with column information 2
Filling in blank rows in a Table of data 2
Drag down to fill in, but copy, not increment? 10
Fill in the blanks 1
Fill cells increment row number i fomula 1
Filling in blanks 3

Top