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

Need Help with a VBA subroutine 0
Autonumber field in Excel that behaves the same as Access 0
Dealing with a Pivot Table (when I don't want to) 0
Sorting rows 16
Make elements in a row space between instead of wrapping when choosing multiple columns 0
Multiple IF Statement in Word 5
How can I print rows that go outside of the page without shrinking the text? 0
How can I copy data produced by a formula, not the formula? 2

Top