Copy and Paste cells with formulas without formula adjustment

I would like to copy a range of cells (interactively) which contains formulas with references to other cells. By default, the references in the target cells will be adjusted by the relative offset of the destination cell to the source cell (unless the reference is absolut, i.e. $A$1).
I'm looking for a way, that this adjustment is not applied without using absolut references in the source cells, i.e. copy literally.
Paste Special only allows me to either select 'formula' (with adjustment) or 'value' (but I need the formulas!) - so 'paste special -> literally' would be nice...

Is there a way to achieve this?

Many thanks in advance!

Try replacing = with something like #, copy/paste, replace # with =

maybe try like this:

copy the formula to notepad, then replicate it the amount of times you need (let's say you wanna spread it to 10 cells, then replicate it 10 times), copy the text from notepad, then paste it back to excel.

Originally Posted by Armando Montes

Try replacing = with something like #, copy/paste, replace # with =

Nice idea (like all the others!) - I will try this!

Many thanks! What is the right/best function to copy with a macro?

Originally Posted by Armando Montes

Try replacing = with something like #, copy/paste, replace # with =

Genius.

Well, it's pretty helpful to know that there isn't way to do what I was trying to do - thanks!

I did find a reasonable work-around, though, for my very specific case. Certain 'delete cells' actions will shift the formulas without auto-adjusting the references. So I copied the formulas to new cells to point the references where they needed to point, then deleted the intervening cells.

(I am dealing with columns of data where the 'meaning' of each column varies but there are relationships between the columns that require formulas to decipher. New data will be analyzed in the future, but the format will be unchanged, so it's worthwhile spending the time to set up the spreadsheet to decode this mess once and then be able to just drop in new data in the future.)