The easiest way to flip rows and columns in Excel is to copy the range, choose an empty destination cell, then select Home > Paste > Transpose. For a version that updates when the source changes, enter =TRANSPOSE(A1:D3) in a blank cell instead, replacing the example range with yours.
What flipping rows and columns means
Excel calls this operation transposing. It changes the orientation of a rectangular range: each source row becomes a destination column, and each source column becomes a destination row. The values are repositioned; the operation does not sort the data or reverse the order within a row or column.
For example, suppose A1:C2 contains this two-row layout: “North, Central, South” across the first row and “18, 24, 15” across the second. Transposing that range produces two columns and three rows: North beside 18, Central beside 24, and South beside 15. A range that is 2 rows by 3 columns becomes 3 rows by 2 columns.
This is useful when a report expects categories down the left side rather than across the top, when a chart or template needs a different layout, or when a short list is easier to read vertically. Transposing is distinct from sorting, which changes order according to values, and from moving a range, which relocates it without changing its shape.
Quickest method: Paste Special with Transpose
For a one-time rearrangement, Paste Special is usually the simplest choice. It creates a separate copy in the new orientation, leaving the original range where it is.
- Select the cells to flip. Include the full rectangular range, including any row or column labels that should move with the data.
- Copy the selection with Ctrl+C on Windows. On Mac, use Command+C.
- Click a blank cell where the upper-left corner of the transposed result should go. Leave enough empty space to fit the reversed dimensions.
- Choose Home > Paste > Transpose. Depending on the ribbon display, Transpose may appear as a button in the Paste menu or as an icon in the Paste Special choices.
For example, copying a range of four rows by two columns requires a destination area at least two rows by four columns. Excel fills the appropriate cells from the destination corner. You can also right-click the destination and look for the Transpose paste option. If the option is not visible, use the Paste menu on the Home tab.
Copy rather than cut the source cells. Transpose is a paste operation, and Excel requires copied cells for this workflow. After confirming that the result is correct, you can remove the original range if it is no longer needed.
Use TRANSPOSE for a result that updates
A formula is better when the source data may change and the flipped view should reflect those changes. With the source range A1:D3 and an empty destination cell F1, enter =TRANSPOSE(A1:D3). In current Microsoft 365 for Windows, press Enter. Excel spills the result into a 4-row-by-3-column area beginning at F1.
The spill range is linked to the source: changing a value in A1:D3 updates its corresponding value in the transposed output. The formula does not alter the source cells. It also does not automatically include new rows or columns added outside the referenced range; edit the formula’s range if the source grows beyond A1:D3.
Leave the cells where the result needs to spill empty. If any cell in the required output area is occupied, Excel displays a #SPILL! error rather than overwriting that content. Clear or move the blocking cells, then the array can populate. You cannot edit just one cell in a spilled result; change the source or edit the formula in its top-left cell.
In older Excel versions without dynamic arrays, select the full destination area first, enter the TRANSPOSE formula, then confirm it with Ctrl+Shift+Enter rather than Enter. The destination must have the reversed dimensions: for a 3-row-by-4-column source, select a 4-row-by-3-column output area. Excel displays the formula in braces in the formula bar for a legacy array formula; do not type those braces yourself.
Choose between a pasted copy and a formula
The key decision is whether the transposed result should be independent or remain connected to the original. Paste Special is convenient for a finished snapshot; a TRANSPOSE formula is appropriate for a view that should stay in sync.
- Choose Paste > Transpose for a quick, one-time layout change, especially when you want to move or share a fixed result.
- Choose TRANSPOSE when the source values will be edited and the destination should update automatically.
- Keep a copy of the original when you might need to compare layouts or undo a mistaken paste.
Paste Special copies the selected cells into a new orientation; it is not a live link to the source. The pasted result can include cell contents and formatting, but it is still a separate pasted range. By contrast, the formula output is calculated from the source and is not a set of independently editable cells. If the source contains formulas, test the output because references in formulas and the resulting values may matter differently to your workbook.
Also consider what should happen to formatting. A transposed paste can carry formatting from the copied cells, which may not suit the destination. You can apply a different number format or style afterward. A TRANSPOSE formula returns values from the source but does not reproduce the source’s cell formatting as a full layout copy; format the result separately if needed.
Common problems and how to fix them
The most common mistake is choosing a destination without enough room. A source range with R rows and C columns produces C rows and R columns. Check those dimensions before pasting or entering a formula, and make sure the output will not overwrite headings, notes, or other data.
- The Transpose option is unavailable: Copy the range first, then select a single destination cell. A cut selection is not the same as a copied range for this operation.
- The formula shows #SPILL!: Clear cells, merged cells, or other obstructions in the area where the output needs to appear. Check that the destination is not inside an Excel table, where spilled array formulas are not supported in the same way as in an ordinary range.
- The result seems out of date: A pasted transpose is a snapshot, so it does not update when the source changes. Use a TRANSPOSE formula if you need a live result.
- Blank source cells appear unexpected: Check how blanks are represented in the output, especially with a formula-based array, before using the result in calculations or a report.
- Formatting looks wrong: Apply the desired number formats, alignment, borders, or column widths after transposing. Cell widths and heights do not automatically become a perfectly matched new layout.
Before replacing or deleting the original data, inspect a few positions: the first and last source rows, the headers, and any formulas or dates. This catches a common orientation error—transposing a range that included an extra heading or omitted a label—before the result is used elsewhere.
Windows, Mac, and Excel for the web
In Excel for Microsoft 365 on Windows, the ribbon route is Home > Paste > Transpose. The Windows copy shortcut is Ctrl+C. On Mac, copy with Command+C; use the Home tab’s Paste options to choose Transpose, or use the available Paste Special menu. Ribbon layout and menu wording can vary slightly by platform or window size, so the transpose option may be shown as an icon.
Excel for the web also supports formula-based transposition in current versions with dynamic arrays, and its ribbon may offer a Transpose paste option after copying cells. If that option is not available in the interface you are using, use the TRANSPOSE formula or open the workbook in the desktop application. In a shared workbook, remember that a pasted result will not track later edits to its source.
Keyboard shortcuts are not required for either method. On Windows, Ctrl+C copies the selection; on Mac, Command+C does the same. There is no need to memorize a platform-specific shortcut for the final transpose step when the ribbon’s Paste menu is available.
Frequently Asked Questions
Can I flip rows and columns without copying the original?
Yes. Enter a TRANSPOSE formula in an empty area to create a linked output, or transpose a copy and delete the source only after checking the result. The formula approach leaves the original cells intact.
Does a transposed formula update when I change the source?
Yes, if you use TRANSPOSE and change a cell inside its referenced range. A Paste Special transpose is a separate copy and does not update when the original changes.
Can I transpose only part of a table?
Yes. Select the specific rectangular range you want to flip. Include labels if they belong in the new layout, and exclude unrelated rows or columns. The selected range’s dimensions determine the size of the result.
Can I transpose an Excel table directly?
You can copy cells from a table and paste the transposed result into a suitable ordinary worksheet range. For a formula-based result, place the spill formula in an area outside the table. Check the output and format it as needed rather than assuming it will retain the original table structure.
Does transpose reverse the order of my data?
No. Transpose swaps rows and columns while preserving the relative positions of items. To change the order as well, use a separate sorting or rearrangement step.
Check the result before relying on it
After transposing, verify that the new headers still describe the data and that the top-left and bottom-right values landed where expected. For a formula result, confirm that the spill range is the intended size and that later source changes flow through. For a pasted result, check that it is an independent snapshot and that its formatting is suitable for the report or worksheet where it will be used.
Related
- Excel Column K Number: What It Means and How to Find It
- ICD-10 Z Codes List in Excel: Find, Import, and Check
- Excel Color Scales: How Conditional Formatting Works
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Delete a Page in Word on Mac Without Losing TextTo delete a page in Word on Mac, select its contents with Go To, then press Delete; for…
- Outlook Signature: Create and Set Up an Email Sign-offTo create an email signature in Outlook, open the signature settings for your version, make a new signature,…
- Schedule an Email in Outlook 365: Step-by-Step GuideTo schedule an email in Outlook 365, compose your message, open the arrow next to Send, choose Schedule…
- Real Estate Expense Tracker Excel Spreadsheet GuideYes. You can make a real estate expense tracker in Excel by recording each expense as one row,…
- Excel Ungroup Columns Shortcut: Keys, Steps, and FixesIn Excel for Microsoft 365 on Windows, select the grouped columns and press Alt+Shift+Left Arrow to ungroup them.…
- How to Add a Second Header in Word on Different PagesTo add a second line to a Word header, open the header area at the top of a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.