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

"MBBeginner" wrote in message ...
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