software

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.
S1475201686
506456
S188838254
15623
56731
S956446321
156323M,
This ought to work...
j-walk.com/ss/excel/usertips/tip040.htm
Jim Cone
San Francisco, USA
www.realezsites.com/bus/primitivesoftware

quot;MBBeginnerquot; gt; 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
156323Debra Dalgleish has some techniques at:
www.contextures.com/xlDataEntry02.html

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

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

--

Dave Peterson

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

quot;Dave Petersonquot; wrote:

gt; Debra Dalgleish has some techniques at:
gt; www.contextures.com/xlDataEntry02.html
gt;
gt; Try the manual method. I've found it's quicker than the code!
gt;
gt; MBBeginner wrote:
gt; gt;
gt; gt; On a large worksheet, is there a way to fill the blanks in a column with the
gt; gt; last filled cell without using the autofill handle? My worksheet is over 2000
gt; gt; rows and I am hoping to find some way to mass fill the blanks in Excel. Here
gt; gt; is a small example of what I am talking about. Thanks for any tips.
gt; gt; S1475 201686
gt; gt; 506456
gt; gt; S1888 38254
gt; gt; 15623
gt; gt; 56731
gt; gt; S9564 46321
gt; gt; 156323
gt;
gt; --
gt;
gt; Dave Peterson
gt;