The Office Newsletter is a
free, opt-in monthly publication full of tips like this one.
Just hit the Subscribe link (above). We promise not to use
your email address for evil, and we will never share your
information with anyone else.Excel: Transpose Data
If you have data in columns and you wish that data were in rows
(or if you have data in rows that you wish were in columns), you do
not need to retype it.
- Simply select the data and hit the Copy button.
- Next, select the cell that you want to become the upper left
corner of the new range of data.
- Go to the menu bar and choose Edit | Paste Special. In the
Paste Special dialog box, choose Transpose.
|
