I have a bunch of formulas in a column that I wish to duplicate exactly into another column, where I will go through and tweak them so that a different function is run on the same parameters. When I do a copy/paste, the cell addresses are all altered to be one higher, which is not desired. The only way that I have found is to move the cells using cut/paste, but then I destroy the source cells, leaving me without the duplicate cells.

If you want more detail, I have a column full of CORREL() calculations, and I want to duplicate them to another column where I will do SLOPE() calculations.