| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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...  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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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... 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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rows & Columns in Excel | Excel Worksheet Functions | |||
| How to swap rows and columns? | Excel Discussion (Misc queries) | |||
| inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| Switch Rows and Columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
