How to change columns to rows and vice versa

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:
    Clipboard Excel 2007
  • 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:

  • On the Home tab, in the clipboard group, select the Paste list and then choose Paste Special:
    Clipboard group Excel 2007
  • Right-click and choose Paste Special... in the popup menu.

    5.    In the Paste Special dialog box, check the Transpose checkbox and then click OK:

Paste Special Excel 2007

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.