In Excel for Microsoft 365 on Windows, copy the cells you want to turn, select the destination’s top-left cell, then go to Home > Paste ▼ > Transpose. You can also right-click the destination and choose the Transpose paste icon; the option appears after you copy a range.
Find Transpose on the Ribbon
Transpose switches a range’s rows and columns: rows become columns, and columns become rows. For example, a range that is three columns wide and two rows tall becomes two columns wide and three rows tall. The command is a paste option rather than a permanent setting, so first copy the source cells.
- Select the rectangular range you want to rearrange.
- Copy it with Ctrl+C. A moving dashed outline usually indicates that Excel has copied the cells.
- Select a blank destination cell, preferably outside the source range, and open Home > Paste ▼.
- Choose Transpose, shown as a paste icon with rows and columns turned. If you hover over the icons, Excel may display a label or preview.
Excel places the upper-left cell of the transposed result at the destination you selected. You do not need to select a destination range of the new dimensions; choosing its top-left cell is enough. The original range remains in place because this is a copy-and-paste operation. If you want to move rather than duplicate the data, you can delete the source after checking the result.
Use the Right-Click Menu or Paste Special
The same command is available from the destination cell’s context menu. Copy the source, right-click the destination, and select the Transpose icon in the paste options. This can be quicker when the destination is already selected and the ribbon is collapsed. The icon’s position can vary with window size and Excel interface updates, so look for the word Transpose or its turned-row-and-column symbol rather than relying on a fixed icon position.
You can also open the full Paste Special dialog. After copying, right-click the destination and choose Paste Special, then select the Transpose checkbox and confirm. The dialog gives you other choices too, such as pasting values or formats. If you only need the ordinary transposed copy, the ribbon or context-menu Transpose option is usually more direct.
On Windows, Ctrl+C copies the range, and Ctrl+Alt+V opens the Paste Special dialog in desktop Excel. The keyboard sequence after the dialog opens can depend on the dialog and Excel version, so using the visible Transpose checkbox is the dependable route. On a Mac, use Command+C to copy, then use the Home ribbon’s Paste options or the Edit/Paste Special menu if available in your build. Excel for the web also offers paste options, but the exact menu presentation can vary; look under Paste after copying, or use the formula method below if the paste command is unavailable.
What Transpose Changes—and What It Keeps
Transpose changes the orientation of the copied cells, not their contents. A header row such as Quarter 1, Quarter 2, Quarter 3 becomes a vertical list, while figures beneath those headers shift into corresponding columns. The result normally carries the source cell formatting as part of the paste. If the source includes fills, borders, number formats, or font styling, inspect the result and adjust it if the layout does not suit the destination.
For example, imagine a table in A1:C3 where the top row contains three month names and each following row contains a category and its values. Pasting with Transpose creates a three-row-by-three-column result. The original remains unchanged, and the pasted cells are a separate copy. If the source contains formulas, the pasted formulas may adapt their relative references to the new positions. Check formulas after transposing, especially if they refer to nearby cells or use mixed and absolute references.
The paste command creates a snapshot, not a live link to the source. If the original values later change, the transposed copy does not automatically refresh. This distinction is important when you are reorganizing a one-time report versus building a layout that must stay synchronized.
Choose Between Paste Transpose and the TRANSPOSE Function
Use Paste Transpose when you want a separate, fixed copy that you can edit independently. Use the worksheet function when the transposed result should reflect changes in the source. In Excel for Microsoft 365, enter a formula in the top-left destination cell, with the source range you want to turn:
=TRANSPOSE(A1:C2)
With the source data in A1:C2, that formula returns a result two columns wide and three rows tall. In current Microsoft 365 Excel, the result spills into the required cells automatically. Keep the destination cells empty; otherwise, Excel may show a spill error because it cannot place the full result. The formula result updates when the source range changes, unlike a pasted copy.
In older Excel versions without dynamic arrays, TRANSPOSE may need to be entered as an array formula: first select an output range with the transposed dimensions, enter the formula, and confirm with Ctrl+Shift+Enter rather than Enter alone. The exact behavior depends on the Excel version. On a Mac, the equivalent array-entry shortcut can differ by keyboard and version; use the version’s Excel help if you are working in a release that requires legacy array entry. Microsoft 365 users generally do not need that extra step.
- Choose paste transpose for a quick, independent copy, such as rearranging a table for a presentation.
- Choose TRANSPOSE when the turned result should update as source cells change.
- Choose Paste Special values if you want fixed results without carrying formulas, and then use Transpose in the paste options where available.
Common Problems and How to Fix Them
If Transpose is missing or unavailable, the most common cause is that Excel does not have a copied cell range ready. Copy the cells again, then open the destination’s paste options before copying anything else. The option can also be difficult to spot when the ribbon is minimized or the Excel window is narrow; expand the ribbon or use the right-click menu.
- The result will not fit: Make sure the destination has enough blank cells for the swapped dimensions. A range that is four rows by two columns needs two rows by four columns after transposing.
- Excel reports that it cannot paste: Choose a destination outside the source and check for merged cells or other occupied cells in the output area. Merged cells can interfere with a rectangular paste.
- The result looks different: Transpose may carry formatting, including number formats and borders. If you want values without the original styling, use the appropriate Paste Special options or reformat the destination afterward.
- Numbers or dates appear unexpectedly: Check the source and destination number formats. Pasting can carry formatting, while a formula-based result may display according to the destination cells’ formatting.
- Formulas return different results: Inspect references in the pasted formulas. Relative references can shift as formulas are placed in new positions. Use absolute references where the formula design requires fixed rows or columns, or paste values if formulas are not needed.
For a formula-based transpose that will not spill, clear cells in the output area and verify that the formula refers to the intended source range. A spill range cannot extend into cells that already contain data, including cells that look blank but contain spaces or formulas returning an empty string. Also check whether the formula is inside an Excel table: dynamic-array spill results do not spill within table cells in the same way they do in a normal worksheet range.
Transpose in Excel for Mac and the Web
Excel for Mac includes transpose paste options, although the ribbon arrangement and shortcut keys differ from Windows. Copy the range, select the destination, and check Home > Paste or the right-click paste menu for Transpose. The Mac version’s menus may use different labels or place Paste Special under the Edit menu. Use the displayed menu command rather than assuming a Windows keyboard shortcut will work on a Mac.
Excel for the web supports common paste operations, but browser and clipboard behavior can affect which options appear. If you do not see Transpose in the paste menu, use the TRANSPOSE function in an empty worksheet area if your Excel web version supports the dynamic formula. You can also open the workbook in the desktop app for a fuller set of Paste Special controls. When collaborating, remember that pasted output is static; a formula is preferable if the result must track later edits.
When Transposing Is Useful
Transposing is useful whenever the shape of data does not fit the next task. A row of dates can become a column for a chart or a data-entry form. A list recorded vertically can be placed across a report header. It can also make a wide source table easier to read in a printed report, though changing orientation alone does not redesign the data or guarantee that a chart will interpret it as intended.
Consider a weekly summary where days run across columns but a chart or downstream process expects each day on its own row. Copying and transposing creates a convenient version without rebuilding the data manually. If the source is updated every week, however, a formula-based TRANSPOSE or another data transformation method will reduce repeated manual work. Check that headings remain paired with the right values, and confirm that totals and labels did not shift out of alignment.
Frequently Asked Questions
Where is Transpose in Excel 365?
Copy a cell range, select the destination, then choose Home > Paste ▼ > Transpose. You can also right-click the destination and select the Transpose paste option.
Can I transpose a range without copying it?
For a dynamic result, enter a TRANSPOSE formula in the destination area. The paste command requires you to copy the source first; it creates a separate, static copy.
Does transposing update when the original data changes?
No, not when you use Paste Transpose. That result is a snapshot. A TRANSPOSE formula is linked to its source and recalculates when source values change.
Can I transpose rows and columns in Excel for the web?
Often, yes: copy the range and check the Paste options for Transpose. If the option is not shown in your browser interface, try the TRANSPOSE function or open the workbook in desktop Excel.
Why is the Transpose option greyed out?
Excel may not have a copied range on the clipboard, or the destination may be unsuitable because of merged or occupied cells. Copy the source again and try a blank destination outside the original range.
Can I transpose formulas and keep them working?
Yes, but inspect the pasted formulas because relative references may adjust to their new positions. If you only need the displayed results, paste values instead of formulas.
Related
- Supply List Excel Template: How to Build and Use One
- Excel Superscript Shortcut: Apply Superscript to Text
- Subscript vs Superscript in Excel: What’s the Difference?
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- PowerPoint Notes: How to Present and Read Speaker NotesTo read your speaker notes while presenting in PowerPoint, add them beneath each slide, connect or identify your…
- Out of Office in Outlook 365: Set It Up on Any DeviceTo set an out-of-office message in Outlook 365, open Automatic replies, turn them on, write your message, and—if…
- Conditional Formatting Between Two Values in ExcelIn Excel for Microsoft 365 on Windows, select the cells you want to format, then choose Home >…
- How to Make a Booklet in Word Back to Back PrintingTo make a back-to-back booklet in Word, set the document’s page layout to Book fold, arrange your content…
- Markdown Table Merge Cells? What You Can DoNo: standard Markdown table syntax has no way to merge cells across rows or columns. If your Markdown…
- Contact List Excel Sheet: How to Build and Use OneYes—a contact list Excel sheet is a workbook for storing and organizing names, phone numbers, email addresses, and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.