Skip to Main Content

Excel: Switching Rows and Columns

Sometimes you encounter data that is arranged in a certain way, but you realize an alternate arrangement of rows and columns better suits the way you want to view the information. For instance, you may want to switch this arrangement:

to this:

The ability to transpose data in this manner, without retyping the entries, resides in the Paste Special dialog box in Excel. To rearrange your data, first select the range of data. Then copy using Ctrl-C or any copying method. Then on the Home tab of the Ribbon, click the drop down arrow under the Paste icon:

When the Paste Special dialog box opens, click the Transpose checkbox at the bottom of the window and click OK:

Paste Special dialog box

Paste Special dialog box

3 Responses to "Excel: Switching Rows and Columns"

  1. Rajeev - RevisionLog Says:

    I had actually wanted to write a VBA macro to do just that. This tip saved me the time. I’m wondering if this feature is present in earlier versions of Excel.

  2. Veronica Mount Says:

    It has been available for quite a few versions. It is under the Paste Special options in those versions too.


  3. Jason F. Says:

    This is a great tip! I’ve never noticed it before!

Leave a Reply


Get Training Tips via RSS Subscribe to Entries feed or Read Comments via RSS Subscribe to Comments feed.