The simplest way: Paste Special with the Transpose option

To change rows to columns in Excel, select your data, copy it, then use Paste Special with the Transpose checkbox. This flips rows into columns and columns into rows in one step.

Here is the exact process: Select all the cells containing your data. Press Ctrl+C (or Cmd+C on Mac) to copy. Click the cell where you want the transposed data to start — usually a blank area to the right or below your original data. Right-click and choose Paste Special, or press Ctrl+Shift+V. In the dialog box that opens, check the Transpose box and click OK.

Your data now appears rotated: what was in row 1 is now in column A, what was in row 2 is now in column B, and so on. The original data stays in place unless you delete it afterward.

Key Takeaways

  • Paste Special with Transpose is the built-in Excel feature that converts rows to columns in seconds without formulas.
  • You must copy the data first — Transpose only works in the Paste Special dialog, not as a standalone command.
  • The transposed data appears as static values, not linked formulas, so changes to the original do not update the copy.
  • If your data includes headers or labels, they transpose along with the numbers, so check that the result reads correctly.

When to delete the original data and when to keep it

After you transpose, you have two copies of the same information — one in the original layout and one flipped. Decide whether you need both before you delete.

Keep both copies if you are building a report that needs the data shown two ways, or if you want to preserve the original layout for reference. Delete the original if you only needed it in the transposed form, or if the flipped version is now your working copy. To delete, select the original data and press Delete to clear the cells, or right-click and choose Delete to remove the rows or columns entirely.

If you delete by accident, press Ctrl+Z when ready to undo.

Using the TRANSPOSE function for linked data

Paste Special creates a static copy — if you change a number in the original data, the transposed version does not update. If you need the transposed data to stay linked to the original, use the TRANSPOSE function instead.

Click the cell where you want the transposed data to start. Type =TRANSPOSE(A1:C10), replacing A1:C10 with the actual range of your data. Press Ctrl+Shift+Enter on Windows or Cmd+Shift+Enter on Mac — this tells Excel to treat it as an array formula. The data appears transposed, and now if you change a value in the original range, the transposed version updates automatically.

The TRANSPOSE function is slower with large datasets and takes up more memory, so use Paste Special for one-time transposing and TRANSPOSE only when you need the data to stay connected.

Transposing data with headers and labels

If your first row contains headers (like "Month", "Sales", "Region") or your first column contains labels (like "January", "February", "March"), they transpose along with the numbers. This usually works correctly, but check the result to make sure the headers and labels still make sense in their new positions.

For example, if your original data has months down the left side and product names across the top, transposing flips it so product names run down the left and months run across. The headers stay attached, so you do not have to re-enter them — but you may need to adjust column widths or formatting to match the new layout.

Fixing column widths after transposing

When you transpose data, the new columns often inherit the width of the original rows, which may be too narrow or too wide for the new content. Excel does not automatically adjust column width to fit the transposed data.

To fix this quickly, select all the transposed data. Double-click the border between any two column headers at the top of the sheet — Excel auto-fits all selected columns to their content. Alternatively, right-click the column header and choose Column Width to set a specific width, or Optimal Width to let Excel decide based on the longest entry in each column.

Transposing only part of your data

You do not have to transpose the entire sheet. Select only the range you want to flip — for example, just the sales numbers without the labels, or just three months instead of twelve. Copy that selection, then use Paste Special with Transpose as usual. Only the selected range appears in the new layout.

This is useful when you have a large spreadsheet but only need one section rotated, or when you want to transpose data into a specific location without moving everything else.

Frequently Asked Questions

Does transposing change the original data?

No. Paste Special creates a separate copy in a new location, leaving the original untouched. If you use the TRANSPOSE function, the original data stays in place and the formula references it. You can delete the original afterward if you no longer need it.

Can I transpose data that has formulas in it?

Yes, but Paste Special converts the formulas to their current values. If you need the formulas to stay active after transposing, use the TRANSPOSE function instead, which preserves the formula references and updates them correctly for the new layout.

What if my data has merged cells?

Transpose does not work well with merged cells — Excel may skip or misalign them. Unmerge the cells first by selecting them, going to the Home tab, and clicking Merge & Center to toggle it off. Then transpose, and re-merge if needed in the new layout.

Can I transpose data from one sheet to another?

Yes. Copy the data from the first sheet, switch to the second sheet, and use Paste Special with Transpose. The data moves between sheets the same way it moves within a sheet. If you use TRANSPOSE, you can reference the other sheet by typing =TRANSPOSE(Sheet1!A1:C10).

Is there a keyboard shortcut for Transpose?

There is no single-key shortcut, but Ctrl+Shift+V opens Paste Special quickly. From there, click the Transpose checkbox or press T to toggle it, then press Enter.