To paste a copied range sideways or upright in Excel for Microsoft 365 on Windows, select the range and press Ctrl+C, click the top-left destination cell, then press Ctrl+Alt+V, E, and Enter. This opens Paste Special and turns on Transpose, swapping rows and columns. Use an empty destination area large enough for the rotated range.
Transposing is useful when information is arranged across columns but needs to run down rows, or the reverse. It changes the layout of the pasted copy; it does not reorganize the original cells. The instructions below cover the Windows shortcut first, along with ribbon, Mac, and web alternatives.
What You’ll Need
- A workbook open in Excel, preferably Excel for Microsoft 365 on Windows for the keyboard sequence in this guide.
- A rectangular block of cells to copy. For example, a range that is 3 columns wide and 2 rows tall will paste as 2 columns wide and 3 rows tall.
- An empty destination area with enough room for the transposed result. The destination can be on the same worksheet or another worksheet in the workbook.
- If using a Mac or Excel for the web, access to the Paste or Paste Special menu. The Windows keyboard sequence may not work the same way there.
Step-by-Step
- Check the source range. Identify the entire rectangular block you want to turn. Click its top-left cell, then drag to its bottom-right cell, or click the first cell, hold Shift, and click the last cell. You can also select a range by clicking the Name Box to the left of the formula bar, typing a range such as A1:C2, and pressing Enter. Make sure the selection includes all intended rows and columns.
- Copy the selected cells. Press Ctrl+C on Windows. A moving dashed border usually appears around the selection, indicating that Excel has copied it. Do not cut the range with Ctrl+X: cutting is intended to move cells, while transposing through Paste Special is a copy-and-paste operation.
- Choose the destination’s top-left cell. Click a blank cell where the transposed result should begin. You only need to select the top-left cell, not manually select the whole destination block; Excel fills the required number of cells. If your source has 2 rows and 3 columns, the pasted result takes up 3 rows and 2 columns. Make sure those destination cells are clear before continuing.
- Open Paste Special. Press Ctrl+Alt+V. The Paste Special dialog should appear. If your keyboard or Excel setup does not open it, use Home > Paste > Paste Special on the ribbon. In some Excel builds, the Paste Special entry is in the Paste dropdown rather than displayed as a separate button.
- Turn on Transpose. In the dialog, press E to select the Transpose option, then press Enter to paste. The familiar Windows sequence is therefore Ctrl+Alt+V, E, Enter, performed after copying and selecting the destination cell. If pressing E does not select the checkbox in your version or with your keyboard layout, use the mouse to check Transpose in the dialog, then click OK. The visible checkbox is the reliable fallback.
- Verify the result. Check that the copied rows now run down columns and the copied columns now run across rows. For example, if the source had three headers in the first row and two records underneath, the output will have three rows and two columns. Check key labels and values before deleting or editing the original.
- Use the ribbon if you prefer not to use the dialog shortcut. Copy the range, select the destination cell, then open Home > Paste and choose Transpose. The exact appearance of the Paste menu can vary with ribbon layout and window size; look for the transpose icon or the Transpose command. This method is often easier to recognize than the dialog shortcut.
- On a Mac, use the menu rather than the Windows key sequence. Copy the source, click the destination, and use Home > Paste to find Transpose if it is shown. You can also open Edit > Paste Special and choose the Transpose checkbox when available. Mac keyboard shortcuts differ from Windows, and the Windows Ctrl+Alt+V, E, Enter sequence should not be assumed to work on a Mac. If the Paste menu does not offer the command, open the workbook in desktop Excel and use Paste Special.
- In Excel for the web, use the on-screen Paste options. Copy the range, select the destination, and look in Home > Paste for Transpose or Paste Special options. Browser shortcuts can be intercepted or differ from desktop shortcuts, so use the visible menu if the Windows sequence does not open the expected dialog. If the transpose option is missing, open the file in the Excel desktop app.
Common Mistakes
Choosing a destination that is too small or already occupied. A transposed block reverses its dimensions. If the source is 5 rows by 4 columns, the result needs 4 rows by 5 columns. Selecting just one destination cell is fine, but the cells around it must be available. Existing content in the output area can block the paste or be overwritten, so check the entire footprint first.
Using a normal paste instead of Transpose. Ctrl+V alone pastes the copied cells in their original orientation. Use the Transpose option in Paste Special or the Transpose command in the Paste menu. If you notice the output has the same number of rows and columns as the source, undo with Ctrl+Z and repeat using the correct command.
Confusing transpose with moving or rearranging the original. Copying and transposing creates a second arrangement; the source remains where it was. If your goal is to move the original cells, plan that separately and verify formulas and references before removing the source. A copied result is not a live link to the original values unless you use a formula-based approach.
Expecting formulas to behave like fixed text. When formulas are copied, Excel may adjust relative references as part of the paste. Review formula cells in the destination, particularly if they refer to nearby cells or use a mixture of relative and absolute references. Values and labels are usually straightforward, but formulas can produce different references after a copy.
Assuming every kind of cell content will transpose identically. Merged cells, filtered ranges, protected sheets, and some complex layouts can complicate a paste. A range containing merged cells may not paste as expected. If the source is part of a formatted report, try a small copy in an unused area first and check the outcome.
Tips
- Use a small test when the workbook matters. Copy a few representative cells to a spare area and inspect the result before transposing a large table. This helps reveal unexpected formatting or formula-reference changes without disturbing the original layout.
- Decide whether to preserve formatting. The standard Transpose paste generally carries cell content and formatting. If you only want the values, use Paste Special and choose Values as well as Transpose if both options are available in your Excel version. Confirm the dialog settings before clicking OK, because selecting one paste type can change what is copied.
- Keep source and output easy to compare. Put the transposed copy on a separate worksheet or leave a blank space between it and the source. Compare the first and last entries, not just the top-left cell, to make sure the full range was copied in the right direction.
- Remember the size swap. A selection that is 2 rows by 8 columns becomes 8 rows by 2 columns. That quick check helps you reserve space and confirm the result after pasting.
- Use a formula only when you need a changing result. Paste Special creates a copy that does not automatically update just because the original cells change. Excel also has a TRANSPOSE function for a formula-driven result, but its behavior and setup differ from a one-time paste. For a quick, independent copy, the Paste Special shortcut is usually more direct.
- Use the dialog fallback if a key does not register. The E in the Windows sequence is a keyboard access key for the Transpose option in the dialog. Dialog details can vary by build, language, or keyboard layout. If the letter does something unexpected, stop and select the checkbox by sight instead of guessing.
Troubleshooting
Ctrl+Alt+V does not open Paste Special: First confirm that you copied cells and selected a destination cell. Then try Home > Paste > Paste Special. Some keyboard utilities or remote desktop tools can intercept shortcuts. In Excel for the web, browser behavior can also differ, so prefer the ribbon menu.
The output is not transposed: Undo the paste with Ctrl+Z, copy the source again, and open Paste Special. Make sure Transpose is checked before confirming. If using the ribbon, choose the command specifically named Transpose rather than the regular Paste button. After pasting, compare the dimensions: the original row count should become the output column count.
Excel reports that the destination is not blank or cannot paste: Check the full area the output would occupy, not just its top-left cell. Clear or move anything in that footprint, including cells that look empty but contain spaces or formulas returning an empty string. If the worksheet is protected, ask the workbook owner or unprotect it if you have permission, then retry.
Only some cells appear, or the result looks irregular: Look for merged cells, hidden rows or columns, and a selection that accidentally omitted part of the source. Re-select a simple rectangular range and test it in a blank part of the sheet. If the original selection contains merged areas, unmerge or copy the relevant values into a plain temporary range before transposing.
Formulas show unexpected results: Click a pasted formula cell and inspect the formula bar to see which references Excel used. If you need the displayed results rather than formulas, undo and repeat using the Values and Transpose options where available. If the formulas must remain connected to the source, consider a formula-based transpose instead of a one-time paste.
The Transpose option is unavailable: Try copying the range again and select a single blank destination cell. Check whether the worksheet is protected or whether the selected source includes merged cells. If using Excel for the web or an older build, use the desktop app or the ribbon’s available Paste options; menu availability can differ by platform and version.
Frequently Asked Questions
What is the Excel shortcut to paste transpose?
On Windows, copy the cells, select the destination, then press Ctrl+Alt+V, E, Enter. If E does not select Transpose in your dialog, check the Transpose box manually and confirm.
Does the transpose shortcut work on a Mac?
The Windows sequence is not the Mac equivalent. In Excel for Mac, copy the range and use Home > Paste to find Transpose, or use Edit > Paste Special and select its Transpose option when available.
Can I transpose without copying the original?
Paste Special Transpose is a copy operation, so it leaves the original in place. If you want to replace or remove the original, check the pasted result first, then handle the source separately.
Will a transposed paste update when I change the source?
No. A normal Paste Special transpose makes a separate copy. For an output that updates from the source, use a formula-based approach, such as Excel’s TRANSPOSE function, and check whether your Excel version supports the way you plan to enter it.
Can I transpose only values and not formatting?
Often, yes. Open Paste Special and choose the Values option along with Transpose if your dialog provides both controls. Menu layouts vary, so verify the selected options before you confirm the paste.
Why is Excel changing my formulas after transposing?
Copied formulas can have relative references adjusted as Excel places them in the new location. Inspect the formula bar in the output. If you need only the displayed results, paste values; if you need linked results, use a formula-based method instead.
Related
- Keep 0 in Front of a Number in Excel Without Losing It
- Excel Share Mode: How to Keep Your Workbook Shared
- Excel Insert Row Shortcut: Steps for Windows and Mac
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- AutoCAD Excel Data Links: Insert and Update TablesTo insert Excel data in AutoCAD as a linked table, run TABLE, choose From a data link, create…
- Data Validation Shortcut Key in Excel: Windows and MacIn Excel for Microsoft 365 on Windows, press Alt, then A, then V, then V to open the…
- Freeze in Excel: Keep Rows and Columns Visible on ScreenTo freeze rows or columns in Excel for Microsoft 365 on Windows, select the cell below the rows…
- How to Hide a Column in Excel and Unhide It EasilyYes. In Excel for Microsoft 365 on Windows, select the column letter, right-click it, and choose Hide. To…
- Can You Group Rows in Smartsheet? Sheets and ReportsYes. In a Smartsheet sheet, you can arrange rows into a collapsible parent-and-child hierarchy; in a row report,…
- How to Color Cells in Excel Based on Values AutomaticallyTo color cells in Excel according to their values, select the range, then choose Home > Conditional Formatting…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.