actually you don't even to drap it down. just double click that excel would do the auto fill down to the end of the column.