flip columns and rows

[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

 

[Frank Kabel]

Hi
have a look at 'edit - Paste Special - Transpose'

 

[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

 

[greg]

thanks, for the quick help

Hi
have a look at 'edit - Paste Special - Transpose'