How to change columns to rows and vice versa

Excel 365 2013 2010 2007 2003
In some cases, you may want to change columns and rows in your data range for more convenient and impressive view. Excel proposes the fast and simple way to change columns and rows in the data range.

Do the following:

   1.   Highlight the data that you want to change in your spreadsheet:

  • the column that you want to change to a row
  • the row that you want to change to a column
  • the data range in which you want to change columns and rows.

   2.   To copy selected information in the clipboard, do one of the following:

  • On the Home tab, in the Clipboard group, click the Copy button:
    Copy button in Excel 2016
  • Right-click in the selection and choose Copy in the popup menu
  • Click Ctrl+C.

   3.   Select the cell where you want to place the changed information.

   4.   To paste changed information, do one of the following:

   4.1.   New features in Excel 2016 (like in Excel 2010):

  • On the Home tab, in the Clipboard group, select the Paste list and then choose Transpose (T):
    Clipboard group in Excel 2016
  • Right-click and choose Transpose (T) in the popup menu:
    popup Clipboard group in Excel 2016

   4.2.   Usual way:

  • On the Home tab, in the Clipboard group, select the Paste list and then choose Paste Special (or right-click and choose Paste Special... in the popup menu):
    Clipboard group in Excel 2016
  • In the Paste Special dialog box, check the Transpose checkbox and then click OK:
    Paste Special in Excel 2016

See also this tip in French: Comment changer les colonnes en rangées et vice versa.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more