flip columns and rows

G

greg

Hello,
is there a way to flip a worksheet?
where the top row will become the left column and
the left column will become the top row?

thanks
 
G

Gord Dibben

Greg

Copy>Paste Special>Transpose.

Note: paste range cannot overlap existing range.

Note: you are limited to 256 rows of Transpose to Columns.

Gord Dibben Excel MVP
 
Top