copying a column of cells containing formulas without them changin

  • Thread starter Christopher Buxton
  • Start date
C

Christopher Buxton

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
 
D

David Biddulph

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.
 
Top