The fastest way to swap rows and columns

To change a row to a column in Excel, use the Paste Special transpose function. Select the row you want to move, copy it, right-click where you want it to go, choose Paste Special, check the Transpose box, and click OK. The row becomes a column in seconds.

This works the same way in reverse — you can transpose a column into a row using the identical steps. Transpose flips your data along a diagonal, so whatever was horizontal becomes vertical and vice versa.

The method works in Excel on Windows, Mac, and the web version. Google Sheets has a similar feature under a different menu path, but the principle is identical.

Key Takeaways

  • Copy the row or column you want to move, then use Paste Special with Transpose checked to flip it to the other direction.
  • Transpose swaps rows and columns at the same time — you cannot transpose just one row without affecting the whole selection.
  • The transposed data lands wherever you click before opening Paste Special, so choose your destination first.
  • If your original data has formulas, they will recalculate after transpose, which may change results if they use relative references.

Step-by-step for Windows Excel

Start by selecting the entire row you want to transpose. Click the row number on the left side to highlight the whole row at once. If you only need part of the row, click the first cell, hold Shift, and click the last cell you want to include.

Press Ctrl+C to copy. Then click the cell where you want the column to start — this is the top cell of your new column. Right-click and select Paste Special from the menu. A dialog box opens.

In the Paste Special dialog, find the Transpose checkbox on the right side. Check it. Leave all other options at their defaults unless you have a specific reason to change them. Click OK. Your row is now a column.

Step-by-step for Mac Excel

Select the row by clicking its number on the left, or select just the cells you need by clicking the first one and Shift-clicking the last. Press Command+C to copy.

Click the cell where you want your column to begin. Right-click and look for Paste Special in the menu. If you do not see it, use the keyboard shortcut Command+Control+V instead — this opens Paste Special directly on Mac.

Check the Transpose box and click OK. The row becomes a column in the location you selected.

Using transpose with multiple rows or columns at once

Transpose works on any rectangular selection, not just single rows. If you select five rows and ten columns, transpose will flip the entire block so it becomes ten rows and five columns. All the data moves at once.

Select your entire data range by clicking the first cell, holding Shift, and clicking the last cell. Or click and drag to highlight everything you need. Copy with Ctrl+C (Windows) or Command+C (Mac).

Click where you want the transposed data to start — usually a blank area so you do not overwrite anything. Open Paste Special, check Transpose, and click OK. The whole block flips.

What happens to formulas when you transpose

If your row contains formulas, they stay as formulas after transpose. However, the cell references change. A formula that pointed to the cell to its left will now point to the cell above it, because the direction has flipped.

If this causes problems — for example, if a formula breaks because it can no longer reach the data it needs — you have two options. You can undo the transpose with Ctrl+Z and rebuild the formulas before transposing again. Or you can use Paste Special with Values checked instead of Transpose, which converts formulas to their results first, then transpose those numbers.

Transposing in Excel Online

Excel Online does not have a Transpose button in the Paste Special menu the way desktop Excel does. Instead, copy your row or column, right-click where you want it, and look for a Paste options icon that appears below the menu. Click it and select the transpose icon — it usually looks like a grid with arrows.

If you do not see the transpose option, switch to the desktop version of Excel. You can read it, use Excel through Microsoft 365, or open the file on a computer where Excel is installed. The desktop version has full transpose support.

When to use transpose instead of manually retyping

Transpose saves time whenever you have more than a few cells to move. If you have a row with 20 values and you need it as a column, transpose takes five seconds. Typing it out takes minutes and introduces typos.

Transpose is also useful when you receive data in the wrong orientation — for example, a report where months run across the top but you need them down the left side. Instead of restructuring the whole sheet, transpose the data once and rebuild your formulas around the new layout.

Frequently Asked Questions

Can I transpose data without overwriting what is already there?

Yes. Click an empty cell or empty area before opening Paste Special. The transposed data lands there instead of replacing your original. You can then delete the original row or column if you no longer need it.

What if I transpose by accident and want to undo it?

Press Ctrl+Z (Windows) or Command+Z (Mac) when ready. This undoes the transpose and puts your data back the way it was. You can undo multiple times if you need to go back several steps.

Does transpose work with text, numbers, and dates all mixed together?

Yes. Transpose flips the data as-is without changing the type of anything. Text stays text, numbers stay numbers, dates stay dates. Everything moves to its new position intact.

Can I transpose just part of a row, or do I have to transpose the whole thing?

You can select just the cells you want. Click the first cell in the row, hold Shift, and click the last cell you need. Copy and transpose only that selection. The rest of the row stays where it is.

What if my transposed column is too narrow to show all the data?

Double-click the border between two column letters at the top to auto-fit the width. Or click and drag the border to make it wider manually. This is a display issue, not a problem with the transpose itself.