Either change the references from relative to absolute (include the $
prefixes) and then copy, or
Go to the formula bar, copy the content from there, paste to your
destination cell.
--
David Biddulph

"Christopher Buxton" wrote in
message ...
I have a column which contains formulas. When i select the column and copy
then paste it into the next column across it changes the formulas. I want
to
be able to copy a cell, row or column without the formula changing. How do
i
do this?


Thanks

Chris