switch rows and columns

  • Thread starter Thread starter tomba545
  • Start date Start date
T

tomba545

I would like to switch my rows and columns.

I have reached the maximum amount of columns in my worksheet, and need
more. The only way to do this is by making rows out of my columns.
Unfortunately I haven't got a clue on how to do this... :confused:

Can anyone help?

Thanks,
Tom
 
Create a new worksheet
Select the range to transpose (on the original sheet)
edit|copy
Select A1 of the new worksheet
edit|paste special|click transpose
 
Wow! It's that easy?

I tried it, only to conclude that I really feel like a dick now :)
Thanks for helping out, won't forget this one any time soon.

Tom
 
Wow! It's that easy?

I tried it, only to conclude that I really feel like a dick now :)
Thanks for helping out, won't forget this one any time soon.

Tom
 
Back
Top