Excel Tip

Transpose Rows and Columns of Data

Have you ever set up a table in Excel with column headings and row headings only to wish that you had designed it the other way with your choices for column headings as row headings and vice versa?  Guess what - Excel lets you switch row and column headings while preserving your data!  Here is how:

1. Select your table of data including column and row headings

2. Copy or cut the data

3. Pick an empty spot in your spreadsheet where you want the new transposed table to start and click in the cell to select it.

4. Choose Edit, Paste Special from the menu (or right click and choose Paste Special)

5. At the bottom of the dialog box click to check  Transpose

6. Click OK

What previously looked like this:

Now looks like this:

Back  to Top

Back to Tips Page