row to column

M

mangesh

hi
I have entered no. 1 to 100 from A1 to A100 i.e in a row. Now i wan
to convert that same from row to column i.e i want to enter 1 in colum
A, 2 in column B and so on. Is there any way for doing that please le
me know
 
J

JulieD

hi

yes,
copy (can't use "cut") the A1:A100 range, click in cell B1 and choose edit /
paste special - transpose
then delete A1:A100 (or column A)

cheers
JulieD
 
Top