View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MBBeginner
 
Posts: n/a
Default How do I auto fill long col. filling blanks with last filled cell

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