Change Column heading to row

L

learning_codes

Hi,

I'm new. I have huge column 200 columns that have heading. I want
200 headings to move 200 rows on the excel spreadsheet.

Your help would be much appreciated.

Thanks
 
T

Tyro

Copy the 200 column headings and paste/special check transpose to the column
where you want the column headers to be row headers. Save your workbook
first.

Tyro
 
G

Gord Dibben

Check out help on "Transpose"

Note: if using any version earlier than 2007 you will be able to transpose only
256 rows to columns.


Gord Dibben MS Excel MVP
 
Top