Excel: Error Message with Paste Special Transpose

ID: Q79626

The information in this article applies to:

Microsoft Excel for Windows, version 2.x, 3.0, 4.0, 4.0a, 5.0
Microsoft Excel for OS/2, version 2.2, 3.0

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 :