Transposing Data in MS Excel
- by Carol Bratt on 20090422 @ 06:09PM EST | google it | send to friends
- Filed under Carol's Corner Office | (related terms: range, transpose, cells)
The Transpose feature in MS Excel is used to change a vertical range of cells to a horizontal range or vice versa.
Follow the steps below to learn how to use this feature:
- Copy of range of cells.
- Select a cell in the current or any other worksheet and right-click.
- From the shortcut menu that appears, select Paste Special.
- Check the Transpose check box.
Voila! Transposed! I know you will make use of this feature often!
When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
