Put the formula in the first cell, select the first cell again and press
ctrl + shift + down arrow to select the whole column, then press Ctrl + d

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com



"dzuy" wrote in message
...
Is there any way to fill (pattern) a formula in every cell in a column
(without the use of a macro)?

Thanks.