Copy and Transpose Paste

H

HAS

As we all knew, Excel can copy values and then paste them with tranpose, can
we do the same for formulas?
 
D

Dave Peterson

I change the formulas to text:
Select the range
Edit|Replace
what: =
with: $$$$$=
replace all

Then I do the copy|paste special|transpose

Then I change both ranges back to formulas:
Select the range
Edit|Replace
what: $$$$$=
with: =
replace all
(and repeat with the other range)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transpose Error 2
Transpose a table 2
transpose 2
dynamic transpose 1
transpose and formulas 3
Run-time error 1004 paste method of worksheet class failed 3
How to transpose a long list of text across cells 2
Transpose Large Column to Row 2

Top