Assuming that you mean column A in the source data table, there are
instructions here for filling blank cells:

http://www.contextures.com/xlDataEntry02.html

Gor_yee wrote:
Just got a quick questions, I've got about 50 different 4 digit numbers
in column A. Each 4 digit number can have about 3-9 blank rows between
it. How can I autofill it?Currently I am just doing the double clicking
and filling..but with 50 different numbers this can be very time
consuming..is there a easier way?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html