If you have less than 256 rows you can CopyPaste SpecialTransposeOKEsc

More than 256 rows would require some VBA to manipulate the data.


Gord Dibben Excel MVP

On Sat, 26 Nov 2005 15:25:02 +0000, kgerlitz
wrote:


How can I flip an entire worksheet and data so that the column headings
across the top become vertical on the left side and all the data flips
accordingly