Hi,

How can I transpose a formula whilst keeping the existing formula!?

I've found how to:
copy->paste special->transpose
but excel updates the formula, to make it relative I assume. However, I want the original formula to be pasted. Any ideas?

Forgive me if this has already been answered somewhere but I can't find it!

Many thanks