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!