How do I auto fill long col. filling blanks with last filled cell

[Guest]

On a large worksheet, is there a way to fill the blanks in a column with the
last filled cell without using the autofill handle? My worksheet is over 2000
rows and I am hoping to find some way to mass fill the blanks in Excel. Here
is a small example of what I am talking about. Thanks for any tips.
S1475 201686
506456
S1888 38254
15623
56731
S9564 46321
156323

 

[Jim Cone]

M,
This ought to work...
http://j-walk.com/ss/excel/usertips/tip040.htm
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

On a large worksheet, is there a way to fill the blanks in a column with the
last filled cell without using the autofill handle? My worksheet is over 2000
rows and I am hoping to find some way to mass fill the blanks in Excel. Here
is a small example of what I am talking about. Thanks for any tips.
S1475 201686
506456
S1888 38254
15623
56731
S9564 46321
156323

 

[Dave Peterson]

Debra Dalgleish has some techniques at:
http://www.contextures.com/xlDataEntry02.html

Try the manual method. I've found it's quicker than the code!

 

[Guest]

It worked. I cannot tell you how thrilled I am. Thank you so much.