Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose, Paste Special
Hello,
I'm just wanting to transpose when pasting some data (rows become columns, vise versa). Other posts on the forum have said to go to the Paste Special option and click on transpose. My Paste Special screen does not show that, I instead have the option of pasting it in a different file format or as a link. A different versio of excel maybe? I'm using Excel 2003 SP2. How do I paste transposed data in my version? Thanks, Jennifer |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose, Paste Special
Are you copying data from somewhere else than Excel? If it is from an Excel
file you should always get a long list of options on how to paste -- Regards, Peo Sjoblom "idgity" wrote in message ... Hello, I'm just wanting to transpose when pasting some data (rows become columns, vise versa). Other posts on the forum have said to go to the Paste Special option and click on transpose. My Paste Special screen does not show that, I instead have the option of pasting it in a different file format or as a link. A different versio of excel maybe? I'm using Excel 2003 SP2. How do I paste transposed data in my version? Thanks, Jennifer |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose, Paste Special
Ah, you are right. I was copying from one Excel spreadsheet to another in a
different instance of Excel, so it gave me the paste special menu for data coming in from another application. If I copy and paste into the same spreadsheet, I get the window everyone was describing. Thanks! Jennifer "Peo Sjoblom" wrote: Are you copying data from somewhere else than Excel? If it is from an Excel file you should always get a long list of options on how to paste -- Regards, Peo Sjoblom "idgity" wrote in message ... Hello, I'm just wanting to transpose when pasting some data (rows become columns, vise versa). Other posts on the forum have said to go to the Paste Special option and click on transpose. My Paste Special screen does not show that, I instead have the option of pasting it in a different file format or as a link. A different versio of excel maybe? I'm using Excel 2003 SP2. How do I paste transposed data in my version? Thanks, Jennifer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Special / transpose | Excel Discussion (Misc queries) | |||
When I special paste and transpose.... | New Users to Excel | |||
Paste Special - Values - Transpose | Excel Worksheet Functions | |||
HELP....Is there a way to automate copy/paste special/transpose - | Excel Worksheet Functions | |||
Trying to transpose linked data using Paste Special | Excel Worksheet Functions |