In Excel can I rotate a column from vertical to horizontal.

K

kend

Data is exported into Excel as a vertical column, is it possible to rotate
the column 90 deg to make it a horizontal row?
 
J

JulieD

Hi

one option, select your data (as long as it's not more than 256 cells) and
copy it
click on a cell (e.g. A1) and choose edit / paste special - transpose
You can then delete the original list

Cheers
JulieD
 
P

Paulw2k

Hi,

Yes, select the items and choose Edit/Copy then select a new cell and choose
Edit/Paste Special and check the transpose-box and hit ok.

Regards
Paul
 
M

microsoft.public.excel.misc

Pls. copy it & then use paste special. there u wil see transpose. use
transpose.
 
Top