If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
When I special paste and transpose....
When I select my row, copy, special paste, and transpose a message that reads:
The information cannot be pasted because the Copy area and the paste area are not the same size and shape. Try one of the following: Click a single cell, and then paste Select a rectangle that's the same size and shape, and then paste I have no idea what this means. Any help out there? Thanks |
#2
|
|||
|
|||
When I special paste and transpose....
Before you paste, you should select where to paste. The easiest approach
will be to select a single cell (that is, click in a single cell which will be the first into which the data is pasted). You should also select it such that, when pasting the transposed row, it will not cross the original source region. Ex: you've selected row 1 and hit edit copy. Now click in cell A2 and THEN paste special, transpose. "sml" wrote: When I select my row, copy, special paste, and transpose a message that reads: The information cannot be pasted because the Copy area and the paste area are not the same size and shape. Try one of the following: Click a single cell, and then paste Select a rectangle that's the same size and shape, and then paste I have no idea what this means. Any help out there? Thanks |
#3
|
|||
|
|||
When I special paste and transpose....
Have you tried selecting a single cell and pasting as the message suggests?
Select the row1 header which selects the entire row. Select cell A2 and paste specialtranspose. Gord Dibben MS Excel MVP On Tue, 10 Jan 2006 16:10:03 -0800, sml wrote: When I select my row, copy, special paste, and transpose a message that reads: The information cannot be pasted because the Copy area and the paste area are not the same size and shape. Try one of the following: Click a single cell, and then paste Select a rectangle that's the same size and shape, and then paste I have no idea what this means. Any help out there? Thanks |
#4
|
|||
|
|||
When I special paste and transpose....
I was able to transpose one item, but when I tried to transpose more than one
the same message came up. I'm not sure what I am doing wrong. Thanks for the help. "Gord Dibben" wrote: Have you tried selecting a single cell and pasting as the message suggests? Select the row1 header which selects the entire row. Select cell A2 and paste specialtranspose. Gord Dibben MS Excel MVP On Tue, 10 Jan 2006 16:10:03 -0800, sml wrote: When I select my row, copy, special paste, and transpose a message that reads: The information cannot be pasted because the Copy area and the paste area are not the same size and shape. Try one of the following: Click a single cell, and then paste Select a rectangle that's the same size and shape, and then paste I have no idea what this means. Any help out there? Thanks |
#5
|
|||
|
|||
When I special paste and transpose....
I'm not sure either.
What are you selecting? Give row number or address of range. Where are you trying to paste special that selection? I have no problem when using the steps I gave at first posting. Gord On Wed, 11 Jan 2006 14:35:03 -0800, sml wrote: I was able to transpose one item, but when I tried to transpose more than one the same message came up. I'm not sure what I am doing wrong. Thanks for the help. "Gord Dibben" wrote: Have you tried selecting a single cell and pasting as the message suggests? Select the row1 header which selects the entire row. Select cell A2 and paste specialtranspose. Gord Dibben MS Excel MVP On Tue, 10 Jan 2006 16:10:03 -0800, sml wrote: When I select my row, copy, special paste, and transpose a message that reads: The information cannot be pasted because the Copy area and the paste area are not the same size and shape. Try one of the following: Click a single cell, and then paste Select a rectangle that's the same size and shape, and then paste I have no idea what this means. Any help out there? Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Paste Special - Values - Transpose | J | Worksheet Functions | 2 | December 6th, 2005 04:25 PM |
how do I transpose and paste a link in excel | JJJ | Worksheet Functions | 4 | April 27th, 2005 02:32 PM |
Copy a Column But Paste it as a transpose and link together? | Gunjani | Worksheet Functions | 4 | May 7th, 2004 03:10 AM |
Paste Special - Transpose | Bonnie | Worksheet Functions | 6 | April 23rd, 2004 05:20 PM |
Paste and transpose data | Nick | Links and Linking | 4 | December 23rd, 2003 08:23 AM |