Excel: Error Message with Paste Special Transpose

ID: Q79626




The information in this article applies to:

SUMMARY



You may receive the following error message when you attempt to use the Paste Special Transpose command in Microsoft Excel:
Copy and Paste Areas Are Different Shapes
This error may occur even though you may have selected a single cell as the paste range. Check to see whether the copied range can fit into the proposed paste range.

MORE INFORMATION

Microsoft Excel spreadsheets have 256 columns and 16,384 rows. If you copy information from 257 rows and attempt to transpose and paste that information, the error always occur because the pasted information now exceeds the 256-column limit. Similarly, if you copy 256 rows, then choose Paste Special from the Edit menu and select the Transpose option with cell B1 currently selected, the same error message results.

Note: this error message is not specific to the Transpose function.

Additional query words:


Keywords          : 
Version           : 
Platform          : 
Issue type        : 

Last Reviewed: March 23, 1999