Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I want to take a list of variable names in a column and transpose it into a row so it corellates against some previously recorded columns of variables and their data. Basically, I can't get the Paste Special / Transpose option to do its business here! I highlight the column, copy it, then higlight the cell I want my new row to start, select Paste Special / Transpose, and then get the message "...the copy area and the paste area are not the same size and shape..." - well , of course not! But that wasn't stipulated in the instructions in the help file, all it said was select the first cell where you want the row to start. How do I get this working, am I overlooking something obvious? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
paste special transpose problem | Excel Discussion (Misc queries) | |||
how to copy a pivot table and "paste special" formats in excel 07 | Excel Discussion (Misc queries) | |||
copy--paste--special "formula" for a whole column | Excel Discussion (Misc queries) | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
Inactivating of "Paste special" while linking charts | Charts and Charting in Excel |