H HAS Feb 15, 2009 #1 As we all knew, Excel can copy values and then paste them with tranpose, can we do the same for formulas?
As we all knew, Excel can copy values and then paste them with tranpose, can we do the same for formulas?
D Dave Peterson Feb 15, 2009 #2 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)
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)
