Copying Cells without changing data

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

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