Copy paste formulas verbatim

Question

Say I have a row of 100 cells, each with some formula.

I want to copy them and paste them to another place, but with the formulas verbatim the same, without changing the link.

Is there a quick way to do this (i.e. without macros, without the need to add $ sign to formulas, etc.)? You would think that there is some way to do this through the Paste Special, but I do not seem to see such an option.

Answer 1

The fastest way that I usually do is to use find > replace...

Do something like this:

• Select the cells that have the formulas you need.
• find > replace excel = , ( #) -
• ,
• find > replace, =

, ( ), .

, .