Introduce Me

Transposing Cells in Microsoft Excel

DID YOU KNOW that one of the most over-looked but extremely useful features in Excel is the Transpose option, which helps you re-orientate the contents of the copied range when you paste it back - entries in rows appear in columns.

Tell Me

The Transpose function changes the horizontal or vertical arrangement of a range of cells.  

To transpose your data, simply

1. Copy the data and then move to the cell where you would like the new data to be entered; and
2. Choose Edit.
3. Paste Special and tick Transpose. The data you copied is now transposed from a row to a column or a column to a row.   That quick and easy.

Show Me

Tip

If you transpose cells containing formulas make sure the references in the formulas are absolute before you copy them.  If you want to learn more about Absolute References refer to that lesson

Let Me Try

Transposing Cells

TIP

If the "OPEN" option does not show you all icons you'd expect in the application, use the "SAVE" option.

Help Me

Remember to put your new skills into practice as soon as possible.  Learn a little each day to improve your knowledge and skills.