How to Switch Rows and Columns in Excel

How to Transpose a Whole Workbook Online

1. Open the free Transpose tool and drop in your .xlsx, .xlsm, or .xls workbook. Everything runs locally — the file is never uploaded.
2. Click Transpose. Every sheet is flipped: the cell at row 1, column 2 moves to row 2, column 1, and so on for every cell.
3. Check the per-sheet report — dimensions before and after (a 3×2 sheet becomes 2×3).
4. Download the result as a clean .xlsx.

The old first column (Name, Ada, Leo) becomes the new first row, and the old second column (City, Paris, Rome) becomes the new second row. Headers, numbers, dates, and empty cells all travel with their values.

• Transpose Excel Rows and ColumnsThe free online tool used in the steps above.

Manual Method: Paste Special → Transpose

1. Select the range you want to flip and copy it (Ctrl+C).
2. Click the top-left cell of the destination — it must have enough empty room below and to the right.
3. Right-click → Paste Special → tick Transpose → OK.

Paste Special Transpose pastes a static copy — it does not move anything, so the original range is still there to delete by hand. And it has a hard ceiling Excel will not warn you about until it fails: a sheet can hold at most 16,384 columns, so transposing a long column of 20,000 rows is simply impossible. Formulas in the copied range are also re-anchored to the new position, which usually wrecks relative references.

For one small range on one sheet, Paste Special is perfectly fine and instant. The costs only appear at scale: one sheet per run, manual cleanup of the source, and the column limit.

The TRANSPOSE Function, and Why People Give Up on It

=TRANSPOSE(A1:C20) returns a live flipped array. In Excel 365 it spills automatically; on older versions it must be entered over the whole target area with Ctrl+Shift+Enter. Either way, the result is a formula:

• The source range is locked — deleting or inserting rows inside it spills #REF! across the flipped copy.
• You cannot edit a single cell of the result; every change goes through the formula and the source.
• Moving the file to another tool (CSV export, import into a database) requires freezing it to values first — a second, separate step.

One more thing worth knowing before you flip: if the range contains formulas, any transposed copy — tool included — carries values, not the formulas. If you want the values frozen deliberately and the formulas gone from the source too, that is a separate, one-click conversion.

• Convert Formulas to ValuesFreeze every formula to its current result, all sheets at once.