Want to Transpose
 

This is probably a silly question... but how can I transpose some cells?

The cells I want to transpose are forumla's, so copy and pasting them
doesn't help.

Quite often I find myself making several comparisons of lists against
themselves, while theres probably an easier method I haven't got that far
yet, and usually end up needing to change something from Horizontal to
Verticle.
At the moment I have to manually enter all the cell references which is
tedious.

Eg.
I have various numbers along the top of the spreadsheet, starting at E1,
these come from Sheet2 where they are calculated.
I then want A5 to be the same as E1
I want A6 to be the same as F1
I want A7 to be the same as G1, etc

Want to Transpose
 

copy=paste special=tranpose


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=521002

Want to Transpose
 

One way...

Select your range to transpose
edit|replace
what: = (equal sign)
with: $$$$$
replace all

Now all your formulas are text.

Do the copy|paste special|transpose. The text "formulas" don't change--since
they're text.

Now select the range and
edit|replace
what: $$$$$
with: =
replace all

(And do the same to the original range, too.)

PaulW wrote:

This is probably a silly question... but how can I transpose some cells?

The cells I want to transpose are forumla's, so copy and pasting them
doesn't help.

Quite often I find myself making several comparisons of lists against
themselves, while theres probably an easier method I haven't got that far
yet, and usually end up needing to change something from Horizontal to
Verticle.
At the moment I have to manually enter all the cell references which is
tedious.

Eg.
I have various numbers along the top of the spreadsheet, starting at E1,
these come from Sheet2 where they are calculated.
I then want A5 to be the same as E1
I want A6 to be the same as F1
I want A7 to be the same as G1, etc

--

Dave Peterson

Want to Transpose
 

Cheers, that's exactly what I needed.