transpose paste special not available

transpose paste special not available

Post by rabz » Mon, 11 Oct 2004 23:33:46



I have copied some table from a web page. I want to transpose th
columns and rows. After I cut the columns, the paste special link i
not available to click on. The only choice is paste link.

the following fixes have also failed:

formatting all to text
moving data to a new workshee
 
 
 

transpose paste special not available

Post by Gord Dibbe » Tue, 12 Oct 2004 03:24:21


When cutting, Paste Special is not available.

Use Copy>Paste Special>Transpose then delete the original columns/rows.

Gord Dibben Excel MVP

On Sun, 10 Oct 2004 09:33:46 -0500, rabz < XXXX@XXXXX.COM >