In Excel for Microsoft 365 on Windows, copy the range, select the destination cell, then press Ctrl+Alt+V, E, and Enter to paste it transposed. There is no single dedicated transpose key: this shortcut sequence opens Paste Special and selects its Transpose option.
What transposing a range does
Transposing switches rows and columns. For example, a horizontal list of four quarter names becomes a vertical list of four names, while the values or other copied cell content move into the corresponding positions in the new orientation. A range that is three columns wide and two rows tall becomes two columns wide and three rows tall.
This is useful when a report, chart source, or form expects data in the opposite orientation from the one you have. It can also help when a table is easier to read with categories down the side instead of across the top. Transpose changes the arrangement of the copied cells; it does not automatically redesign the data or infer a better layout.
Windows shortcut, step by step
- Select the cells you want to turn around and press Ctrl+C. A moving dashed border should appear around the copied range.
- Click the upper-left cell where the transposed result should begin. Choose a blank destination with enough room for the changed dimensions.
- Press Ctrl+Alt+V to open the Paste Special dialog.
- Press E to select the Transpose option in the English-language dialog, then press Enter to paste.
For instance, if you copy a range that is two rows by three columns, reserve a destination area that is three rows by two columns. Selecting just the upper-left destination cell is normally enough; Excel fills the cells needed for the transposed result. If the E key does not select Transpose in your setup, use the dialog’s checkbox instead. Keyboard mnemonics can differ with language or interface changes.
Using the ribbon instead
If you do not want to remember the key sequence, use the ribbon. Copy the source cells, select the destination, and choose Home > Paste to open the Paste menu. Select Transpose from the paste options. The precise appearance of the menu can vary with window size, but the command is in the Home tab’s Paste controls.
The ribbon route is also a useful way to check that you have chosen the right option: Excel labels it Transpose. The Paste Special dialog offers additional controls, such as whether to paste values or formats, while the ribbon’s Transpose option is convenient for a straightforward transposed paste.
Choose a destination and decide what to copy
Before pasting, check the dimensions and contents of both ranges. A transposed result can overwrite existing cells, so choose an empty area or move anything important first. The destination must not overlap the source range. If Excel warns that cells contain data, stop and inspect the selection rather than confirming automatically.
- For a simple copy: copy the source and use Transpose. This generally brings across the copied cell content and formatting.
- For values without formulas: use Paste Special and choose Values as well as Transpose, if the dialog offers both options. This is helpful when you want a snapshot rather than formulas that refer to other cells.
- For a clean presentation: inspect column widths and row heights after pasting. Transpose changes cell placement, but it does not necessarily make the new layout visually fit your intended report.
Paste Special includes several choices because pasting can affect more than displayed numbers. Depending on the selected paste option, formulas, formats, number formats, comments, or other cell properties may be included or left out. If the result looks unexpected, undo with Ctrl+Z and repeat the paste with the appropriate options.
Transpose with a formula
Use the TRANSPOSE function when you want the new arrangement to stay connected to the source. With the original data in cells A1:C2, enter =TRANSPOSE(A1:C2) in a blank cell in Excel for Microsoft 365. The source is two rows by three columns, so the formula spills into a result that is three rows by two columns.
In current Microsoft 365 Excel, the formula returns a dynamic array: enter it in the upper-left cell of the output area and Excel fills the neighboring cells automatically. Changes to the source range flow through to the transposed result. Keep the full spill area clear; if something blocks it, Excel may show a #SPILL! error. To turn the linked result into an independent snapshot, copy the output and use Paste Special > Values.
Older Excel versions without dynamic arrays may require selecting the full output area first and confirming the formula as an array formula with Ctrl+Shift+Enter. Follow the instructions for the specific Excel version in use; that older confirmation method is not needed for a normal dynamic-array formula in Microsoft 365. Use the paste shortcut instead if you only need a one-time copy.
Mac and Excel for the web
On Excel for Mac, the Windows sequence Ctrl+Alt+V, E, Enter is not the shortcut to rely on. Use the Home tab’s Paste menu and choose Transpose, or use the Paste Special command available in your Mac version. Mac keyboard shortcuts can differ by version, keyboard, and settings, so consult the menu’s displayed shortcut if you want to use the keyboard.
In Excel for the web, use the Home tab’s Paste options and look for Transpose after copying the source cells. The browser and operating system can affect keyboard combinations, so the visible menu is the dependable route when the Windows shortcut does not work. If the option is unavailable in the current context, the TRANSPOSE formula is another way to arrange the data, provided the web version supports the function and there is space for its result.
Common problems and fixes
- The sequence opens a different window: confirm that Excel is active and that the copied cells are selected. Use the ribbon’s Paste menu to find Transpose if another application or system shortcut intercepts the keys.
- The transpose option is unavailable: copy the source range first. Paste Special options depend on having copied cells, and some paste choices are not available for every kind of copied content.
- The result is blocked: clear the destination cells, check for merged cells, and make sure the destination area is large enough. For a formula result, remove any content in the array’s spill area.
- The formulas show unexpected references: a pasted formula can adjust relative cell references for its new position. If you need the displayed results rather than working formulas, paste values or use a formula that explicitly preserves the references you need.
- The pasted result is not linked to future edits: Paste Special Transpose creates a pasted copy, not a live view of the source. Use
=TRANSPOSE(A1:C2)with the source in A1:C2 when the output should update as that range changes.
One common misconception is that transpose always means “rotate the data and keep everything else identical.” It changes the row-and-column arrangement, but the outcome depends on what you paste. Formulas may adjust, formatting may come along, and column widths or row heights may need separate attention. Check the result before using it in a report or calculation.
Frequently Asked Questions
What is the shortcut to transpose in Excel?
On Windows, copy the range, select the destination, and press Ctrl+Alt+V, E, then Enter. This opens Paste Special and selects Transpose in the English-language dialog.
Is there one key that transposes cells immediately?
No. Excel does not provide a single dedicated transpose key. The Windows key sequence uses Paste Special; the ribbon’s Home > Paste > Transpose command is an alternative.
Can I transpose data without copying it?
Yes. With the source range in A1:C2, enter =TRANSPOSE(A1:C2) in a blank cell in Microsoft 365. The result is linked to the source and updates when the source changes.
Why can’t I select Transpose?
Make sure you copied a range before opening Paste Special, and check that you are pasting into a suitable destination. If the keyboard mnemonic does not work, select the Transpose checkbox in the dialog or use the ribbon menu.
Does transpose work on Excel for Mac?
Yes. Use the Paste menu’s Transpose option in Excel for Mac. The Windows shortcut sequence differs, so use the command shown in the Mac interface rather than assuming the Windows keys will apply.
Related
- Excel Template for a Social Media Calendar
- How to Freeze Rows and Columns in Excel
- Freeze in Excel: Keep Rows and Columns Visible on Screen
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- How to Filter Highlighted Cells in Excel by Cell ColorTo filter highlighted cells in Excel, turn on filtering, open the drop-down arrow in the column that contains…
- RANK Excel Function: Examples, Ties, and Sort OrderTo rank a value in Excel, use RANK.EQ(number,ref,[order]): for example, with scores in B2:B6, =RANK.EQ(B2,$B$2:$B$6,0) returns B2’s position…
- Excel Count Dates Older Than Today: Formula and FixesTo count dates in Excel that are earlier than today, use =COUNTIFS(A2:A100,"
- Excel XIRR With Dates: Formula, Examples, and FixesTo calculate a return from cash flows that happen on specific, uneven dates, use Excel’s XIRR function: with…
- Excel Sort A to Z: How Numbers Are SortedIn Excel, Sort A to Z sorts numeric values in ascending order—from the smallest number to the largest.…
- Excel Filter Shortcut: Turn Filters On and Use ThemIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off for the current…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.