Transpose Data in Excel: Shortcut and Paste Special

How-to basics · Updated November 20, 2026

To transpose data in Excel on Windows, copy the range with Ctrl+C, select an empty destination cell, then press Ctrl+Alt+V, E, and Enter. Excel pastes the rows as columns and the columns as rows. The destination area must be clear and large enough for the turned-around range.

What You’ll Need

  • A workbook open in Microsoft Excel for Microsoft 365 on Windows. The main shortcut also works in many recent desktop versions of Excel.
  • The source range you want to turn around. You can select a rectangular block of cells; a range with two rows and three columns will become three rows and two columns.
  • An empty destination area that will fit the transposed result. Leave room below and to the right of the destination cell.
  • Access to the Paste Special dialog. In English-language Excel for Windows, the keyboard sequence Ctrl+Alt+V, then E, then Enter selects the Transpose option. If the dialog uses different key tips in your language, select the Transpose checkbox with the mouse instead.

Step-by-Step

  1. Check the source data. Identify the full rectangular range to turn around, including any headings you want to keep. For example, if months are in the first row and product names are in the first column, include both sets of labels when selecting the block. Avoid selecting extra blank rows or columns unless you intend to transpose them too.
  2. Copy the range. Select the source cells, then press Ctrl+C. A moving dashed border usually appears around the copied range. Copying is important: the Transpose option is available in Paste Special after copying, not after simply cutting the cells.
  3. Choose the destination. Click the upper-left cell where the transposed result should begin. Choose a location outside the source range if you want to keep the original data. Make sure the cells that the result will occupy are empty; for a 2-row-by-3-column source, reserve 3 rows by 2 columns.
  4. Open Paste Special. Press Ctrl+Alt+V. The Paste Special dialog appears. You can also open the Home tab, use the Paste dropdown, and choose Paste Special if you prefer the ribbon or the keyboard sequence does not work on your setup.
  5. Turn on Transpose. In the dialog, select the Transpose checkbox. In the standard English Windows dialog, pressing E moves to or toggles this option. If other options are selected, such as Values or Formats, check them before continuing: those choices affect what Excel pastes.
  6. Complete the paste. Press Enter or click OK. Excel fills the destination with the rows and columns exchanged. Check that headings, numbers, and any formatting appear as intended before deleting or changing the original range.
  7. Clear the copy outline. Press Esc when you are done. This cancels the active copy outline; it does not undo the paste. If the result is wrong, press Ctrl+Z right away, then repeat the steps with the correct range or Paste Special options.

Example: Suppose A1:C2 contains a 2-by-3 table: the first row is North, South, and West; the second is 12, 15, and 9. Transposing it produces a 3-by-2 table: North and 12 in the first row, South and 15 in the second, and West and 9 in the third. The values and labels move together, while the orientation changes.

The menu route is Home > Paste dropdown > Transpose in Excel for Windows when the Transpose command is available in the paste options. If you do not see it there, use Paste Special and select its Transpose checkbox. On a Mac, copy the range and use the Home tab’s Paste menu or Edit > Paste Special, then choose Transpose; the keyboard shortcut differs by Excel for Mac version and keyboard layout. In Excel for the web, use the Home tab’s paste options if Transpose is offered. If it is not available in your browser, open the workbook in the desktop app and use Paste Special.

Common Mistakes

  • Choosing a destination that overlaps the source. Excel may refuse the operation or replace cells you meant to keep. Paste into an empty area with enough room, or copy the source to another worksheet before transposing it.
  • Not reserving the right dimensions. A source with four rows and five columns becomes five rows and four columns. Check the new height and width before pasting, particularly near the bottom or right edge of a worksheet.
  • Using Cut instead of Copy. Paste Special transpose is intended for copied cells. If you cut the source, the transpose option may be unavailable or behave differently. Copy first, confirm the result, and remove the old cells later if needed.
  • Assuming every paste option is a live link. A regular Paste Special transpose creates a pasted copy, not a continuously synchronized view. Changes to the source will not automatically update that result.
  • Expecting formula references to stay fixed. When formulas are transposed, Excel may adjust relative cell references, just as it does during a normal copy and paste. Review the pasted formulas before relying on them.
  • Overlooking merged cells or a filtered layout. Merged cells can prevent a rectangular paste from fitting, and copying only visible cells in a filtered range can give an unexpected selection. Unmerge cells where appropriate and verify exactly which cells are copied.
  • Expecting the keyboard letter to work in every language. The E key tip is for the standard English Windows dialog. If it does not select Transpose, use the checkbox in the dialog rather than repeatedly pressing keys.

Tips

  • Use Paste Special when you need a one-time rearrangement. It is quick and leaves the result as a separate set of cells. This is usually the simplest approach for reorganizing a report or preparing a table for printing.
  • Choose the paste type deliberately. The default transpose paste generally carries cell contents and formatting. To paste only the displayed results, select Values in Paste Special as well as Transpose. To keep formulas, use the formula-related paste option if needed, then inspect references and number formats.
  • Keep a backup for a large rearrangement. Copy the worksheet or workbook first when the original table is important. Transposing does not delete the source when you copy, but later cleanup or additional edits can be hard to reverse after other changes.
  • Use a formula if the result should update. For example, assume A1:C2 contains the source values 1, 2, 3 in the first row and 4, 5, 6 in the second row, and you want a live transposed result beginning in E1. Enter =TRANSPOSE(A1:C2) in E1. In Microsoft 365, the formula spills into E1:F3 and returns rows 1, 4; 2, 5; and 3, 6. Keep that spill area clear. A formula result updates when the source changes, unlike a regular transpose paste.
  • Know the difference between formulas and pasted values. TRANSPOSE in a current Microsoft 365 worksheet returns an array that spills into neighboring cells. In older Excel versions, it may need to be entered as a legacy array formula across a preselected destination range using Ctrl+Shift+Enter. That legacy entry method is not necessary in Microsoft 365.
  • Check print layout after rearranging. Transposing a wide table into a tall one can affect page breaks, column widths, and readability. Adjust column widths and review Print Preview before sharing or printing the sheet.

Troubleshooting

Ctrl+Alt+V does not open Paste Special: Make sure Excel has focus and that you copied a cell range first. On some keyboards or systems, another application or utility may intercept the shortcut. Use Home > Paste > Paste Special instead, then select Transpose in the dialog.

The Transpose checkbox is unavailable: Copy the cells again with Ctrl+C and reopen Paste Special. If you used Cut, selected a non-cell object, or copied from a context where Excel does not support that paste option, the checkbox may be disabled. Try a small test range of ordinary cells to isolate the issue.

Excel says the destination is not blank or the paste cannot be completed: Cancel the dialog, clear the intended destination cells, and check for merged cells or an existing array formula in that area. Confirm the destination fits the reversed dimensions. If the source has two rows and eight columns, the destination requires eight rows and two columns.

The result is missing cells or looks misaligned: Undo with Ctrl+Z, select the source again, and check the moving border to verify the exact range. Include or exclude row and column headings deliberately. Also check whether filters or hidden rows have affected what you selected.

Values appear but formulas or formatting are different: Reopen Paste Special and select the appropriate paste type along with Transpose. If formulas were pasted, inspect their references. If you only need the values currently displayed, choose Values and Transpose rather than a formula-preserving option.

A TRANSPOSE formula returns #SPILL!: Clear cells in the expected spill area, including cells that look blank but contain spaces or formulas. Also check for merged cells. The formula needs room for the full transposed array.

Frequently Asked Questions

What is the Excel shortcut to transpose data?
On Windows, copy the range, select the destination, and press Ctrl+Alt+V, E, Enter. This opens Paste Special, selects Transpose in the standard English dialog, and pastes the turned-around range. If E does not work in your language or setup, click the checkbox.

Can I transpose data without copying it?
For the Paste Special shortcut, copy the source range first. If you want a result linked to the source rather than a one-time copy, use the TRANSPOSE function in Microsoft 365 and leave space for its spilled result.

Does transposing change the original data?
No, not when you copy and paste. The original range remains in place, and Excel creates a separate transposed copy. You can delete the original afterward if that is your goal, but check the new table first.

Will a transposed copy update when I edit the source?
A regular Paste Special transpose does not update when the source changes. Use a TRANSPOSE formula for a linked result, or repeat the copy-and-paste operation when you need a refreshed static copy.

How do I transpose data in Excel for Mac?
Copy the range, select a clear destination, and choose Transpose from the Paste menu or the Paste Special dialog. Keyboard shortcuts vary between Mac Excel versions and keyboard layouts, so use the visible menu command if the Windows sequence does not apply.

Can I transpose a table with headings?
Yes. Include the heading cells in the copied range if you want them to turn around with the data. Check the new layout afterward, especially if the headings are merged, formatted as an Excel Table, or used by formulas elsewhere.

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.