Transpose in Excel: The Shortcut Key and How to Use It

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, copy the range with Ctrl+C, select the top-left cell where the transposed copy should go, press Ctrl+Alt+V, press E, then press Enter. This Paste Special shortcut swaps rows and columns, turning rows into columns and columns into rows. The source range stays in place; Excel creates a separate transposed copy.

Before starting, make sure the destination has enough empty cells and does not overlap the copied range. The shortcut applies to a copied selection, not simply to cells that are selected but never copied.

What You’ll Need

  • An Excel workbook open in the desktop version of Excel for Microsoft 365 on Windows.
  • A rectangular range of cells to turn sideways. For example, a range three columns wide and two rows tall becomes two columns wide and three rows tall.
  • An empty destination area large enough for the new shape, with its top-left cell selected before you paste.
  • Permission to edit the sheet. If it is protected, you may need the sheet password or an unprotected destination.

Step-by-Step

  1. Select the source range. Drag across the cells you want to transpose, or click the first cell, hold Shift, and click the last cell. Include only the cells that belong in the copied block. If the top row contains headings, include those headings if they should become a column in the result. Check the selection outline to confirm that the intended rows and columns are included.
  2. Copy the selection. Press Ctrl+C. A moving dashed border, often called marching ants, normally appears around the copied cells. Do not press Ctrl+X: cutting is not needed, and the purpose here is to leave the original range intact.
  3. Choose the destination’s top-left cell. Click an empty cell where the result should begin. Do not select a destination block of the original dimensions; Excel calculates the new dimensions when it transposes. For instance, a source that is 4 rows by 2 columns needs room for 2 rows by 4 columns. Leave that full destination area empty so existing values are not overwritten.
  4. Open Paste Special. Press Ctrl+Alt+V. Excel opens the Paste Special dialog. This is different from ordinary paste: it lets you select the Transpose option while deciding how the copied cells should be pasted.
  5. Turn on Transpose. In the English-language Windows dialog, press E to select the Transpose checkbox. If the checkbox is already selected, pressing its access key may clear it, so look at the dialog before continuing. If the letter does not select the option in your language or setup, use Tab and the arrow keys to move to Transpose, then press Space to check it.
  6. Finish the paste. Press Enter, or move to the OK button and press Enter. Excel places the transposed range at the selected starting cell. Check the new orientation and confirm that the final row and column are where you expect.
  7. Clear the copy border if needed. Press Esc once to stop the marching ants after pasting. This does not remove the pasted result. It simply ends copy mode, which can prevent an accidental second paste later.
  8. Verify the result before deleting or editing the source. Compare a few values, especially the first and last cells, with the original. The transposed block should have the original number of columns as its number of rows, and the original number of rows as its number of columns.

For a concrete example, suppose A1:C2 contains a two-row, three-column block: the first row has Quarter, Q1, Q2, and the second has Revenue, 120, 150. Copy A1:C2, select E1, and use the shortcut. The result occupies E1:F3: Quarter and Revenue appear in the first column, while Q1 and Q2 appear across the next row and 120 and 150 across the row below. The original cells in A1:C2 remain unchanged.

You can also use the ribbon if you prefer not to remember the key sequence: copy the range, select the destination cell, then choose Home > Paste and select Transpose from the paste options. The exact appearance of the paste gallery can vary with window size, but the command is in the Home tab’s Paste menu.

On Mac, the Windows sequence is not the best shortcut to rely on. Copy with Command+C, select the destination, and open Paste Special with Control+Command+V where that shortcut is available; then select Transpose in the dialog. You can instead use the Paste Special or Paste menu on the ribbon and choose Transpose. Excel for the web also offers a Transpose paste option in its paste menu in supported current versions, but shortcut behavior can depend on the browser and keyboard settings. Use the visible menu if a desktop keyboard sequence does not open the expected dialog.

Common Mistakes

  • Using ordinary paste. Ctrl+V pastes the range in its original orientation. Use Paste Special and enable Transpose, or choose the Transpose paste option from the ribbon.
  • Pressing the shortcut before copying. Paste Special needs a copied range on the clipboard. Select the cells and press Ctrl+C first; selecting a range alone is not enough.
  • Choosing the wrong starting cell. Excel places the upper-left corner of the result at the active destination cell. If you click one cell too far left or down, the whole result shifts. Undo immediately with Ctrl+Z and paste again at the correct location.
  • Not allowing for the changed dimensions. A 3-by-5 source becomes a 5-by-3 result. Check for values, formulas, or merged cells in every cell the new block will occupy. Excel may warn before replacing existing content; do not accept that warning unless overwriting is intentional.
  • Expecting a live link to the source. A transposed paste is normally a one-time copy, not a permanently linked view. If the original changes later, the pasted result does not automatically update just because it was transposed.
  • Trying to paste over the source. The source and destination cannot overlap for this operation. Select a separate empty area, or transpose to another sheet, then copy the finished result back only if you have planned how to avoid overwriting the source prematurely.

Tips

  • Use a new worksheet for a large or important result. This gives you room to check the output and reduces the chance of overwriting nearby data. You can move or copy the verified result afterward.
  • Choose the kind of paste you actually need. The Transpose checkbox works with the other Paste Special choices. If you want values without formulas, select Values as well as Transpose; if you want the copied formatting, retain the relevant formatting option. Read the dialog choices before confirming so the result includes the content you intend.
  • Remember that formulas may adjust. Transposed pasted formulas are copied formulas, and relative cell references can change based on the destination just as they do with a normal paste. Check formulas that refer to nearby cells. If the result must stay fixed, consider pasting values instead, after confirming that formulas do not need to remain active.
  • Use the ribbon when keyboard access keys differ. The letter used inside Paste Special can vary by Excel language, and dialog focus or settings may affect which key activates a checkbox. The Home tab’s Paste menu makes the Transpose choice visible.
  • Keep the source until you verify the output. A quick comparison of labels, totals, and edge cells can catch a shifted selection or an unexpectedly changed formula before you rely on the new layout.

Troubleshooting

Ctrl+Alt+V does nothing: Confirm that Excel has focus and that you copied a range. Some Windows utilities or remote-desktop setups may intercept shortcuts. Open Home > Paste > Paste Special instead, then select Transpose.

Pressing E does not check Transpose: The access key may be different in a localized Excel installation, or the dialog may have a different active control. Look for the Transpose checkbox and reach it with Tab, arrow keys, and Space. Confirm that it is checked before choosing OK.

The result is still in the original orientation: Undo with Ctrl+Z, reopen Paste Special, and check that Transpose is selected before confirming. If you used the ribbon, make sure you chose Transpose rather than a standard paste option.

Excel reports that the destination is not empty: Cancel the paste and choose a clear area large enough for the swapped dimensions. If you are certain the existing data can be replaced, make a backup or move it first rather than dismissing a warning without checking what will be lost.

The paste is blocked or incomplete: Check whether the sheet is protected, whether the copied range or destination contains merged cells, and whether the destination is inside an Excel table. Transposing into ordinary worksheet cells is often the simplest workaround: paste into a clear range outside the table, review it, and then decide how to incorporate it. If the workbook is in a shared or restricted editing state, confirm that you have permission to change the destination.

Frequently Asked Questions

What is the shortcut key to transpose in Excel?
On Windows, copy the range, select the destination, press Ctrl+Alt+V, press E to select Transpose in the English Paste Special dialog, then press Enter. If E is not the access key in your installation, select the checkbox with the keyboard or use the ribbon menu.

Does transpose move the original cells?
No. Paste Special with Transpose creates a copy in the new orientation and leaves the source where it is. To make the transposed version your only copy, verify it first, then remove the original separately.

Can I transpose cells without the keyboard shortcut?
Yes. Copy the cells, select the destination, and use Home > Paste > Transpose. In Excel for Mac or the web, the exact menu layout can differ, so look in the Paste menu for the Transpose option.

Will the transposed cells update when the source changes?
Not with an ordinary Paste Special operation; it produces a static copy of the current content. If you need an updating result, Excel also has the TRANSPOSE worksheet function in current Microsoft 365 versions, but that is a formula-based approach rather than the paste shortcut.

Can I transpose formulas and formatting too?
Yes, Paste Special can transpose copied formulas and, depending on the selected paste options, formatting. Relative formula references may adjust at the destination. If you need only displayed results, choose Values along with Transpose, and check the output before relying on it.

Why does my transposed result have a different shape?
That is expected: the source’s rows become columns, and its columns become rows. A block that is 2 rows by 6 columns becomes 6 rows by 2 columns. Make sure the destination is clear across that entire new footprint.

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.