If you have data in an adjacent column, e.g. you want to autofill column
B and you already have data in A1:A30000 (without blanks) you can just
double click the "fill handle" (thats the black + that appears when you
put the cursor on the bottom right corner of the cell) and it should
fill down automatically


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=506519