How to Switch a Row to a Column in Excel 2013

While you might have a good idea of the layout of the data that you are adding to a spreadsheet, changes in the scope of a project, or the addition of more data could change that.

It can be frustrating to cut and paste a lot of data in Excel when you need to move it around, and that becomes even more complicated when data that is already in a row needs to go to a column or vice versa.

Luckily Microsoft Excel has a helpful paste option that will let you switch from a row to a column in your spreadsheet.

Our tutorial below will show you how to select existing data in Excel and use the Transpose option to convert it from a row to a column.

How to Convert a Row Into a Column in Excel

  1. Open your spreadsheet.
  2. Select the cells to convert.
  3. Right-click a selected cell and choose Copy.
  4. Click the cell where you want to paste the data.
  5. Choose the Home tab.
  6. Click the Paste button, then select the Transpose option.

Our guide continues below with additional information on how to switch a row to a column in Excel, including pictures of these steps.

Occasionally you might find that you have laid out data in a spreadsheet in a different manner than you actually need it.

This can be frustrating, and the prospect of essentially redoing the exact same task again might not be appealing.

Fortunately, you can convert a row into a column in Excel 2013 by taking advantage of a feature called Transpose.

Transposing data in an Excel spreadsheet allows you to copy a series of data that is currently in a row, then paste that same data into a column instead.

This can be immensely helpful when a spreadsheet has been laid out incorrectly, and it can help to minimize potential mistakes that can occur when you need to re-enter large sequences of information.

Transposing a Row to a Column in Excel 2013 (Guide with Pictures)

In the tutorial below we will be converting data from a row to a column.

Note that the new location of the data cannot overlap the original location of the data.

If this presents a problem, then you can always use the first cell under your target destination row, then delete the original row. Click here to learn how to delete a row in Excel 2013.

These steps will show you how to switch a row to a column in an Excel spreadsheet.

Step 1: Open your spreadsheet in Excel 2013.

Open your Excel file.

Step 2: Highlight the data that you wish to transpose to a column.

select data to transpose

Select the row data to convert.

Step 3: Right-click the selected data, then click the Copy option.

copy selected cells

Copy the selected data.

Note that you can also copy data by pressing Ctrl + C on your keyboard.

Step 4: Click inside the cell where you would like to display the first cell in the new column.

select top row for column of data

Choose where to put the data.

Step 5: Click the Home tab at the top of the window.

click the Home tab

Choose the Home tab.

Step 6: Click the arrow under the Paste button at the left side of the ribbon, then click the Transpose button.

click the Paste arrow, then click transpose

Click Paste, then Transpose.

You can now delete the original row by right-clicking the row number at the left side of the spreadsheet, then clicking the Delete option.

delete original row of data

Now that you know how to switch a row to a column in Excel you will be able to move your data around a little more easily when you have cells that are in the incorrect type of cell range.

Frequently Asked Questions About Changing a Row to a Column in Microsoft Excel

How do I insert a row in Microsoft Excel?

If your spreadsheet is already full of data and you need to add some data in the middle of it, then you don’t need to cut and paste everything to move it down a row.

If you right-click on the row number below where you wish to add the new row you can select the Insert option to place a new blank row above that row.

How do I add a column in an Excel spreadsheet?

Adding a new column to your spreadsheet is similar to adding a new row.

You can right-click on the column letter to the right of where you wish to add the new column, then choose the Insert option from that menu.

Can I delete a row or a column in Excel?

Yes, it’s possible to delete an entire row and all of the data that is contained within the cells in that row or column.

If you right-click on a row number or a column letter, it will select that entire range and open a contextual menu with some options.

One of those options is “Delete” which you can select the delete the whole column or row from your worksheet.

How do I create a new worksheet tab in an Excel workbook?

If you aren’t copying and pasting data to move it to a different location in the same spreadsheet, then you might be planning to put it into a new blank spreadsheet.

Rather than creating an entirely new Excel workbook file, you can click the plus button to the right of your worksheet tabs at the bottom of the window.

This will create a new, blank worksheet tab where you can paste copied data from other worksheets in your workbook.

Is there a worksheet in an Excel file that you would like to use in a different Excel file? Learn about copying entire worksheets in Excel 2013 and make it easier to reuse your most helpful spreadsheets.

Additional Sources

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy

Newest Guides