Excel Transpose Shortcut: Flip Rows and Columns Fast

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, copy the cells, select the top-left destination cell, press Ctrl+Alt+V, press E to select Transpose, then press Enter. This Paste Special shortcut flips rows into columns and columns into rows; on Mac, use Paste Special from the menu or its keyboard shortcut where available.

The Windows shortcut, step by step

Transpose rearranges the orientation of a rectangular range. For example, a row containing January, February, and March becomes a vertical column, while a table with three rows and two columns becomes a table with two rows and three columns. The source cells stay where they are; Excel creates a transposed copy at the destination.

  1. Select the source range and press Ctrl+C. Copying is important: the Paste Special transpose option is available for copied cells.
  2. Click a blank cell where the upper-left corner of the rearranged range should go. Do not select an entire destination range; choosing its first cell is sufficient.
  3. Press Ctrl+Alt+V to open the Paste Special dialog.
  4. Press E to select the Transpose option, then press Enter to paste. If the letter does not select the checkbox in your dialog, use the mouse or Tab to reach Transpose and check it.

For instance, copying A1:C2 and pasting with Transpose selected produces a three-row, two-column result at the destination. Check that the destination area has enough room and does not contain information you want to keep: the result will occupy a rectangle whose row and column counts are reversed.

Using the ribbon instead of the keyboard

If you prefer visible controls, copy the range, select the destination cell, and choose Home > Paste to open the Paste menu. Select Transpose from the paste options. In Excel for Microsoft 365 on Windows, the Paste Special dialog is also available through Home > Paste > Paste Special. The exact appearance of the menu can vary with the Excel window size and ribbon layout, but the Transpose command is a paste option, not a command that edits the original range in place.

When using keyboard KeyTips, press Alt to display ribbon key letters, then follow the letters shown on your screen for Home and Paste. KeyTips can differ between ribbon layouts or versions, so follow the displayed prompts rather than relying on a memorized sequence. The Ctrl+Alt+V dialog route is a convenient direct method on Windows.

What Paste Special Transpose changes

Transpose swaps the rows and columns of the copied cells. A range that is four rows tall and three columns wide becomes three rows tall and four columns wide. The cell at the source range’s upper-left corner maps to the destination’s upper-left corner; the remaining cells retain their relative order as the range turns.

Paste Special can transfer more than displayed text. Depending on the selected paste option, the result may include values, formulas, number formats, and other cell formatting. The standard Transpose paste option applies the copied cell content and formatting in the new orientation. If you need only the displayed results rather than formulas, choose a values-only paste option and enable Transpose in Paste Special. Inspect the Paste Special dialog before confirming if preserving a particular feature—such as formulas, number formats, or formatting—is important.

Formulas in a copied range can adjust references as they would in a normal copy, in addition to being transposed. That means a formula referring to a nearby cell may refer to a different address after being pasted elsewhere. For important calculations, check a few formulas in the result and confirm that they still point to the intended cells. If you need a live, automatically updating transposed view, a TRANSPOSE formula is often a better fit.

When to use the TRANSPOSE formula

Use the TRANSPOSE function when the rearranged output should update as the source changes. In Excel for Microsoft 365, enter the formula in the top-left cell of an empty output area and let the result spill into neighboring cells. For example, if the source occupies A1:C2, enter =TRANSPOSE(A1:C2) in an empty cell. The result spills into three rows and two columns; changing a source value updates the corresponding result.

Leave the expected output area clear. If a cell in the spill area is occupied, Excel may show a #SPILL! error instead of displaying the full result. Remove or move the blocking content, and the array can spill. A spilled result is linked to the source, so you generally cannot edit just one cell in the result independently. To make a separate, editable copy, copy the result and paste values.

In older Excel versions without dynamic arrays, TRANSPOSE is an array formula: select the full output range first, type the formula, and confirm it with Ctrl+Shift+Enter. Microsoft 365 users normally enter it in a single cell and press Enter; Excel fills the required output range automatically. If the function is not recognized or behaves differently, check which Excel version is installed.

Choosing between paste and a formula

The best method depends on whether the result must stay connected to the original data. Paste Special Transpose creates a copy that is suitable for a one-time layout change, preparing a report, or moving a table into a format required by another tool. A TRANSPOSE formula is useful for a dashboard or working sheet that should reflect later edits to its source.

  • Choose Paste Special Transpose when you want a separate result that you can edit, format, or send on its own.
  • Choose TRANSPOSE when the output should recalculate from its source range as the source changes.
  • Paste values after using a formula if you want the current results to become a fixed, independent copy.
  • Use a manual copy-and-paste approach for a small range if you do not need the result to update and only a few cells are involved.

Neither approach changes the original range automatically. If the goal is to replace the original table with its transposed version, place the output somewhere else first, verify it, and then decide whether to remove the source. Excel cannot safely paste a range over itself as a transpose when the source and destination overlap.

Mac and Excel for the web

On Excel for Mac, copy the range, select the destination, and open Home > Paste > Paste Special or use the Paste Special command in the menu. Choose Transpose in the dialog and confirm. The shortcut commonly used to open Paste Special on Mac is Control+Command+V, but keyboard behavior can vary with the Excel release and Mac keyboard configuration. If that combination does not open the dialog, use the menu path rather than assuming the Windows shortcut applies: Ctrl+Alt+V is the Windows shortcut.

Excel for the web runs in a browser, so some keyboard combinations may be intercepted by the browser or operating system. Use the Home tab’s paste options and look for Transpose, if it is offered in the current interface, or use a TRANSPOSE formula in a blank area. Availability and paste-menu details can change as the web app is updated. If you cannot find the command, opening the workbook in the desktop app is a practical alternative.

Common problems and how to fix them

  • The Transpose option is unavailable. Copy the source cells first, then open Paste Special. The option may not be enabled if you have not copied a cell range or if the current clipboard contents are not cells.
  • The result overwrites something. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, if the operation is still the most recent action. Then choose a blank destination with enough space for the reversed dimensions.
  • The formula result shows #SPILL!. Clear cells in the expected output area, including cells that may appear blank but contain spaces or formulas. The output needs an unobstructed rectangle.
  • The pasted formulas return unexpected values. Review the references in the transposed formulas. Copying formulas to a new location can adjust relative references; use absolute references in the source formulas where appropriate, or paste values if formulas are not needed.
  • The table has merged cells. Merged cells can prevent a paste from fitting the destination shape. Unmerge cells in a copy of the source or create a clean range before transposing, then check the layout before replacing anything.

For a large or important workbook, paste the result in a separate sheet first. That makes it easier to compare the new arrangement with the source and reduces the chance of losing data through an accidental overwrite.

Frequently Asked Questions

What is the direct shortcut to transpose in Excel?

On Windows, copy the range, select the destination cell, press Ctrl+Alt+V, press E for Transpose, and press Enter. It is a Paste Special sequence, not a single shortcut that transposes selected cells in place.

Can I transpose data without copying it?

Paste Special Transpose requires copied cells. If you want a result that updates from the source, enter a TRANSPOSE formula in an empty area instead. Both methods create output elsewhere; neither turns the original range around in place.

Does transposing a range keep its formatting?

The standard Transpose paste option transfers cell formatting along with the copied content. If you want a different result, use Paste Special options for values, formulas, or formats and check the dialog settings before pasting.

How do I transpose a row into a column in Excel?

Copy the row, choose the top cell of a blank destination column, and use Paste Special with Transpose selected. For a linked result in Microsoft 365, use a TRANSPOSE formula referring to the row; Excel spills the returned values vertically.

Why does Ctrl+Alt+V not work on my computer?

That is the Windows Paste Special shortcut. On Mac, use the menu or the Mac Paste Special shortcut; in a web browser, keyboard commands can vary or be intercepted. You can also reach the command through the Home tab’s Paste options.

A quick way to remember it

For a one-time rearrangement in Windows, remember copy, destination, Ctrl+Alt+V, E, Enter. Use the TRANSPOSE function when the result should remain linked to the source, and use Paste Special when you want an independent copy. Before pasting, confirm the destination is clear and large enough; afterward, verify formulas or formatting if they matter to the workbook.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.