Transpose Rows and Columns in Excel

Work smarter, not harder!

Excel Tip – How many times have you created a spreadsheet and then realized after the fact that you should have used the current column headings as row headings and vice versa? I think it has probably happened to most of us a time or two! This tip will show you how to transpose rows and columns very easily while keeping your formatting and formulas.

 Transpose Rows & Columns

  1. Select all consecutive cells that will be transposed.
  2. Copy the selected cells to the clipboard.
  3. Click in the destination cell where the transposed rows and columns are to be pasted.
  4. On the “Home” tab, in the “Clipboard” group, click the Paste button drop-down arrow and in the Paste area, click the Transpose button. The rows and columns are transposed!

Watch the video below and see how to transpose rows and columns in Excel. If you need help or information about the tip, contact us and we will be happy to go over it with you.