how can i change row's data into column and vice versa in ms excel?

1 ⤊

how can i change row's data into column and vice versa in ms excel?

2007-03-31 21:06:27 · 2 answers · asked by Anonymous in Computers & Internet ➔ Software

2 answers

Highlight the cells and go to Edit->Copy (or ctrl-C) to copy

Click on a destination cell and go to Edit->Paste Special...

Select the Transpose option.

Delete the original data.

2007-04-02 18:52:52 · answer #1 · answered by Dan A 2 · 1⤊ 0⤋

Please click this link.
http://office.microsoft.com/en-us/excel/HP052031381033.aspx

2007-04-01 04:12:56 · answer #2 · answered by Hyder 2 · 0⤊ 0⤋