switch rows and columns

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
 
D

Dave Peterson

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
 
T

tomba545

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
 
T

tomba545

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do number columns first, then the rows in an excel footer? 1
Maximum Rows and Columns 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
VBA - retrieve data on last create named range from previous inserted named range 0
changing sheet size 2
How do I swap data in columns and rows around? 2
Update worksheet when changing another sheet 7
deleting blank rows 3

Top