You did nothing wrong. That's how Transpose works.

See a reply at your other posting.


Gord Dibben MS Excel MVP

On Sat, 17 Jan 2009 09:15:01 -0800, Bobby wrote:

Transposing paste the numbers in the wrong direction, I do something wrong?
Thanks

"Angela in Virginia" wrote:

Copy the cells you want, and then Edit - Paste Special - Transpose checkbox
in the bottom and click OK.

"Bobby" wrote:

I know how to copy and paste cells copy cells down then they past down "easy"
but can cells be copied down to up and then paste up? Copy cells 5-4-3-2-1 in
that order bottom cell to top cell then paste in cell #5 and have them paste
upwards? Just backwards of the normal way.
Thanks for any help
Bob