- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

Paste an Exact Match

Paste an Exact Match

Do you often use the same formula in multiple places in your MS Excel worksheets? I’m talking about the exact same formula. You know, no cell reference changes on the paste.

If so, have you ever tried to copy that formula from one cell to another?

Yeah, I know, all the cell references change in the pasted version relative to its new location. Not what you were hoping to accomplish, huh?

Looking for a method you can use to copy and paste the formula, without the cell references changing?

While I’m positive most people have different solutions to this dilemma, I have one to suggest that may not be on your list of tricks.

Voila! The formula is pasted without any changes.

Don’t you just love it when things go your way?!

~ April