Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Paste Special / Transpose" problem
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Paste Special / Transpose" problem
hi.
that is the way it's suppose to work. the only thing i can think of is.... how may items in the list you are transposing? does it exceed avaible columns? regards. FSt1 "M_Hopwood" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Paste Special / Transpose" problem
Yes, I see now... cutting it into sections does indeed work.
I didn't think I'd exceeded the available columns but that seems to be the answer!!! "FSt1" wrote: hi. that is the way it's suppose to work. the only thing i can think of is.... how may items in the list you are transposing? does it exceed avaible columns? regards. FSt1 "M_Hopwood" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Paste Special / Transpose" problem
glad to help.
regards FSt1 "M_Hopwood" wrote: Yes, I see now... cutting it into sections does indeed work. I didn't think I'd exceeded the available columns but that seems to be the answer!!! "FSt1" wrote: hi. that is the way it's suppose to work. the only thing i can think of is.... how may items in the list you are transposing? does it exceed avaible columns? regards. FSt1 "M_Hopwood" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |