convert column to a row

G

Glenn

I have a spreadsheet that has only one column of data.

I'd like to convert it from a column to a row.

Is this possible? How?

Thanks!
 
G

Gord Dibben

If the column has no more than 256 cells with data, you can copy and paste
special>transpose>OK>Esc

Note: it must be pasted outside the selected 256 cell range.

i.e. no overlap


Gord Dibben MS Excel MVP
 
Top