In Excel for Microsoft 365 on Windows, copy the cells, select an empty destination, then press Ctrl+Alt+V, E, and Enter to open Paste Special and transpose the copied range. You can also use Alt, H, V, T in sequence, or enter =TRANSPOSE(A1:C2) when you want a formula-linked result.
What transposing cells does
Transposing switches the orientation of a rectangular range: rows become columns, and columns become rows. For example, a range with three rows and two columns becomes a range with two rows and three columns. The values keep their relative order, so the first source row becomes the first destination column.
This is useful when a report is arranged across a page but a chart, analysis, or data-entry layout works better down a page. It can also help when importing data that has field names in the wrong direction. Transpose changes the layout, not the meaning of the data, and it does not automatically redesign labels or correct inconsistent entries.
Excel offers two broad ways to transpose. Paste Special creates a separate copy of the source cells, while the TRANSPOSE function creates an output linked to the source range. The right choice depends on whether you need a one-time rearrangement or an output that updates when the original data changes.
Windows keyboard shortcut: Paste Special
The Paste Special shortcut is the fastest built-in option for a static transposition in desktop Excel. Copy the original range rather than cutting it; Excel’s transpose paste works from copied cells. Then select the top-left cell where the new arrangement should begin.
- Select the source cells and press Ctrl+C.
- Click an empty destination cell outside the source range.
- Press Ctrl+Alt+V to open the Paste Special dialog.
- Press E to select the Transpose option, then press Enter.
In many Microsoft 365 Windows installations, the ribbon key sequence Alt, H, V, T also reaches the Transpose command. Press the keys one after another, not all at once. Key tips can vary with Excel versions, language settings, and ribbon configuration, so the dialog method is a useful fallback. If the letter key does not select Transpose in your dialog, use the mouse to check the Transpose box and confirm.
You can also use the interface: after copying, open Home > Paste and choose Transpose from the paste options. Depending on the ribbon width, you may need to open the Paste drop-down to see the option. The destination must have enough clear space for the flipped range.
How the transpose paste behaves
Paste Special places a separate result in the worksheet. It is not a live link to the original cells: changing a source value later does not normally update the pasted result. The pasted content follows the selected paste settings. The standard Transpose choice generally transfers the copied cells with their contents and formatting; using a values-only paste option, where available, instead avoids carrying formulas and formatting in the same way.
If the source contains formulas, the pasted formulas may adjust relative references to suit their new positions, just as formulas can adjust during ordinary copying. Inspect a few formulas after transposing if their references matter. For a fixed snapshot with no formulas, paste values after the transposition or use the available values-and-transpose paste option in your Excel build.
Copied source cells remain on the clipboard after a paste, so Excel may continue showing a moving border around them. Press Esc to clear that border; doing so does not remove the pasted result. If the outcome is wrong, use Ctrl+Z promptly to undo the paste and try again.
Mac and Excel for the web
On Excel for Mac, use the ribbon or menu rather than assuming the Windows Alt-key sequence applies. Copy the source, select the destination, then use Home > Paste and choose Transpose if it is shown. Excel for Mac also provides Paste Special options through the Edit menu in many versions. The exact keyboard combination for opening Paste Special differs from Windows and can depend on the Mac keyboard and Excel version; the visible menu command is the dependable route.
In Excel for the web, try Home > Paste and look for Transpose. Browser clipboard permissions and the web app’s available paste options can affect what appears, so the command may not be available for every copy source or selection. If the menu option is missing, enter a TRANSPOSE formula instead, or open the workbook in desktop Excel for the Paste Special workflow. The formula method works in current Microsoft 365 versions of Excel for Windows, Mac, and the web.
Use TRANSPOSE when the result should update
In Microsoft 365, TRANSPOSE is a dynamic array function. Enter it once in the top-left output cell; Excel spills the result across the required number of rows and columns. For example, if the source data occupies A1:C2 and the output should begin in E1, enter this in E1:
=TRANSPOSE(A1:C2)
The source is two rows by three columns, so the result occupies three rows by two columns, from E1 through F3. When a source value changes, the corresponding transposed result updates. Do not type into the other cells in the spill area: Excel controls those cells as part of the formula result.
The output range must be clear. If existing content, merged cells, or another obstacle blocks the spill, Excel reports a #SPILL! error; clear the obstructing area or choose a different starting cell. Dynamic array formulas cannot spill from inside an Excel table, so place the formula outside a table if necessary. In older Excel versions without dynamic arrays, select the full output area first, enter the TRANSPOSE formula, and confirm it with Ctrl+Shift+Enter. That legacy array-entry method is not needed for Microsoft 365.
Choosing between Paste Special and a formula
- Choose Paste Special for a one-time rearrangement, a handoff, or a layout you want to edit independently afterward.
- Choose TRANSPOSE when the source is expected to change and the new orientation should stay synchronized.
- Choose values-only output when you need a fixed snapshot without live formulas or unwanted source formatting.
- Keep the source intact if you may need to compare the two layouts or update the transposed result later.
A formula is not always the better choice just because it updates. It remains dependent on its source range, and downstream users may find a spilled result less convenient to edit cell by cell. Conversely, a pasted copy is convenient for editing but can become out of date. Decide based on how the workbook will be maintained, not just on which method takes fewer keystrokes.
Common problems and practical checks
The most common problem is choosing a destination that overlaps the copied range or does not have enough room. A two-by-three source needs a three-by-two destination. Leave the full destination area blank, especially when using the TRANSPOSE formula, which needs the entire spill area to be available.
- Nothing appears: Check that the source was copied and that you selected a destination cell before invoking Paste Special.
- The output is not linked: That is expected with a normal transpose paste. Use TRANSPOSE if changes to the source must flow through.
- Formulas look different: Relative references can shift during copying. Review the pasted formulas or use a values-only result when formulas are not needed.
- The Transpose option is unavailable: Copy cells rather than cutting them, and select a compatible destination. If you copied data from another application, copy it within Excel and try again.
- Formatting is unexpected: Paste Special may bring over formatting. Try a values-focused paste option or reapply destination formatting after the operation.
For a simple check, transpose a small sample first. If A1:C2 contains 10, 20, 30 in its first row and 40, 50, 60 in its second, the transposed output should have 10, 40 in its first row, 20, 50 in its second, and 30, 60 in its third. This confirms both the orientation and the order before you rearrange a larger worksheet.
Frequently Asked Questions
What is the shortcut key to transpose in Excel?
On Windows, copy the range, select the destination, and press Ctrl+Alt+V, then E, then Enter in the Paste Special dialog. The ribbon key sequence Alt, H, V, T may also work in current desktop Excel.
Can I transpose data without copying it?
For Paste Special, copy the cells first; cutting and pasting is not the standard transpose workflow. If you want a linked output, enter the TRANSPOSE function in a separate, clear area instead.
Does transposing update when the original cells change?
A normal Paste Special result is a separate copy and does not stay synchronized. A TRANSPOSE formula in Microsoft 365 updates when values in its referenced source range change.
Can I transpose rows and columns in Excel for Mac?
Yes. Use the Transpose option under Home > Paste when available, or use the Paste Special command from the menu. The Windows keyboard sequence is not a reliable Mac shortcut.
How do I undo a transpose?
Press Ctrl+Z on Windows immediately after the paste. On Mac, use Command+Z. If you have made other changes since transposing, undo may reverse those later actions first, so check the worksheet before continuing.
Related
- Capitalize First Letter in Excel Quickly
- Superscript in Excel: Quick Key and Formatting Steps
- Quick Key to Zoom In Excel: Shortcuts and Zoom Options
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Add a Grid Header in Microsoft WordIn Word for Microsoft 365 on Windows, open the document and choose Insert > Header > Grid in…
- Create a Fillable Template in Word: Step-by-StepTo create a fillable template in Word, turn on the Developer tab, add content controls such as text…
- Excel Power Query Tutorial: Clean and Combine DataExcel Power Query is a built-in tool for importing, cleaning, reshaping, and combining data, then loading the results…
- How to Loop a PowerPoint SlideshowTo loop a PowerPoint slideshow in Microsoft 365 for Windows, open the presentation and select Slide Show >…
- Excel Data Analysis Skills: What They Include and WhyExcel data analysis is the skill of turning raw spreadsheet data into reliable summaries, comparisons, and decisions. It…
- Can You Merge Cells in Smartsheet? What to Do InsteadNo—Smartsheet does not let you merge cells in a sheet. There is no merge command that combines adjacent…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.