Hi Blueeyes

You can autofill down a contiguous column by double-clicking the little
autofill button the bottom right-hand corner of a cell.

Hope this helps.
Andy.

"Blueeyes" wrote in message
...
Hi all,

I am importing some data from a database to excel and is using some
formulas
in some of the columns to manupulate the data. Every time I import the
data I
got different number of rows and this is in order, because the database
ghanges. My problem is that I cant manage to get the formulas to adjust to
the number of rows I get automaticaly.

I have to copy the formulas manualy depending on the number of rows I get.
Is it possible to get excel to copy the formulas to the right number om
rows
Idepending on the number of rows I import?

Thanks in advance