Copying Cells without changing data

[That's Confidential]

I currently have a number of cells which contain some functions, referring
to specific cells. As these fall onto a new page, I want to copy these cells
and paste them somewhere else in my spreadsheet. When however, I copy and
Paste Special, the data changes, so for example =A1-C2 becomes =J1-K2.

Anybody know how I can copy and paste cells but keep the existing formulas
and the existing data?

Thanks

I

 

[Don Guillett]

You could use absolute references $a$1

 

[Vasant Nanavati]

Use absolute references, e.g.:

=$A$1-$C$2

 

[That's Confidential]

Thanks all!

Problem solved

 

[Chris R. Lee]

This question was asked recently. The solution I find most useful is to use
search/replace to change the equals sign to # or something, and to change it
back after doing the copy.

Regards