switch rows and columns
 

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


--
tomba545
------------------------------------------------------------------------
tomba545's Profile: http://www.excelforum.com/member.php...o&userid=35042
View this thread: http://www.excelforum.com/showthread...hreadid=547886

switch rows and columns
 

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



tomba545 wrote:

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

--
tomba545
------------------------------------------------------------------------
tomba545's Profile: http://www.excelforum.com/member.php...o&userid=35042
View this thread: http://www.excelforum.com/showthread...hreadid=547886

--

Dave Peterson

switch rows and columns
 

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


--
tomba545
------------------------------------------------------------------------
tomba545's Profile: http://www.excelforum.com/member.php...o&userid=35042
View this thread: http://www.excelforum.com/showthread...hreadid=547886

switch rows and columns
 

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


--
tomba545
------------------------------------------------------------------------
tomba545's Profile: http://www.excelforum.com/member.php...o&userid=35042
View this thread: http://www.excelforum.com/showthread...hreadid=547886