Transposing Data in MS Excel

Dennis Faas's picture

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!

| Tags:
Rate this article: 
No votes yet