Flip Paste in Excel: Turn Rows Into Columns Easily

To flip-paste a range in Excel for Microsoft 365 on Windows, select and copy the cells, click a blank destination cell, then choose Home > Paste > Transpose. This swaps rows and columns: a horizontal row becomes a vertical column, and a vertical column becomes a horizontal row. The instructions below explain how to do it, choose the right destination, and fix common problems.

What You’ll Need

An Excel workbook with the range you want to transpose.
A blank destination area large enough for the flipped range. For example, a range that is 3 columns wide and 2 rows high will need a destination 2 columns wide and 3 rows high.
Permission to edit the destination cells. A protected sheet or occupied cells can prevent pasting.

“Flip paste” usually means transposing, not reversing the order of items. Transposing changes the direction of the layout; it does not turn the first item into the last or mirror text. If you mean reverse the order of a list, see the relevant note in Tips.

Step-by-Step

Select the source range. Click the first cell you want to flip, then drag to the last cell. You can also click the first cell, hold Shift, and click the last cell. Check that the selection includes all the rows and columns you intend to copy, including any headings. Avoid selecting entire worksheet rows or columns unless you actually need them.
Copy the range. Press Ctrl+C on Windows. A moving dashed border should appear around the copied cells. Use Copy rather than Cut: a transposed paste is made from a copy of the source, and the original range remains in place. On a Mac, use Command+C.
Choose the destination’s top-left cell. Click a blank cell where the flipped range should begin. Excel expands the result from this cell down and to the right. You do not need to select the whole destination beforehand, but you do need to leave enough empty space for the full result.
Open the Transpose paste option. On Windows, go to Home > Paste and select Transpose from the paste options. Depending on the ribbon layout, Transpose may appear as an icon in the Paste dropdown; hovering over an icon can show its name. You can also right-click the destination cell and choose a Transpose option under Paste Options. In some layouts, open Paste Special and check Transpose, then select OK.
Check the new layout. Compare the result with the source. The first source row should appear as the first destination column, and the second source row as the next destination column. Confirm that labels and values line up as intended before deleting or editing anything.
Choose whether to keep or remove the original. The transpose operation does not remove the source cells. Leave them in place if you need both layouts. If you want to replace the original, verify the pasted result first, then clear the old range separately. This gives you a chance to recover if the destination was not what you expected.

For example, suppose A1:C2 contains “Name,” “Age,” and “City” across the first row, with “Mina,” “34,” and “Leeds” across the second. Transposing that 2-row-by-3-column range into E1 produces a 3-row-by-2-column result: Name and Mina in the first row, Age and 34 in the second, and City and Leeds in the third. The values stay associated with their labels, but the orientation changes.

Excel for Mac has the same basic workflow: select and copy the cells, select a blank destination, then use the Transpose option in the Paste or Paste Special controls. The ribbon’s location and icon arrangement can differ slightly by Excel version, so look for the word “Transpose” in the paste menu. In Excel for the web, use the copy command and the paste options available from the Home ribbon or right-click menu; if the option is not visible in your browser, open the workbook in the desktop app and use its Paste Special controls.

Common Mistakes

Using Cut instead of Copy. Copy the range first. Transposing is a paste operation, and copying keeps the source intact while you check the result.
Choosing a destination with existing data. A transposed range can overwrite cells in its footprint. If Excel warns about replacing content, cancel and choose a blank area, or confirm only when you are certain the cells can be replaced.
Allowing too little room. A range with four rows and two columns becomes two rows and four columns. Check the new dimensions, especially when working near the edge of the worksheet.
Expecting a reversed list. Transpose changes rows to columns and columns to rows. It does not reverse the order within a row or column.
Assuming the result stays linked to the source. A normal transpose paste creates a pasted copy, not a live connection. Editing the original later will not necessarily update the pasted range.
Overlooking formatting or formulas. The paste option can carry cell formatting and formulas as well as displayed values. Check number formats, borders, and formula references in the result.

Tips

Keep a clear gap around the destination. Placing the result a few columns or rows away from the source makes it easier to compare the two and lowers the chance of overwriting data.
Decide whether you need formulas or just values. A standard Transpose paste may carry formulas. If you only need the current displayed results, use Paste Special and choose Values if that option is available in your Excel version, then use the transpose option as well. Check the final cells, since the available combinations can vary by menu.
Check formulas after transposing. When formulas are copied, Excel may adjust relative cell references based on the new location. Review important formulas in the destination rather than assuming they still point to the intended cells.
Use a formula when you need a live transpose. In Microsoft 365, a TRANSPOSE formula can display a transposed range that updates when its source changes. This is different from the one-time Paste > Transpose command. A formula-based result spills into adjacent cells, so keep that area empty. If the cells are already occupied, Excel cannot display the full result.
If you meant reverse rather than transpose, use a helper approach. For a short list, add an index column with numbers in the order you want, then sort by that column in reverse order. That changes the sequence; it does not rotate the range. Make a copy first if the existing order matters.
Keep headers with their data. If the first row contains field names, include it in the selection so each heading is flipped along with its values. Leaving headers out can make the transposed data harder to interpret.

Troubleshooting

Transpose is missing from the menu: Make sure you copied a cell range and selected a single destination cell. Open the full Paste or Paste Special menu instead of choosing a basic paste icon. In Excel for the web, try the desktop app if the browser menu does not show the option.
Excel says the paste area is not blank: Cancel the paste, then click a blank cell with enough room in both directions. Clear existing destination contents only if you are sure they are no longer needed. Also check for cells that look empty but contain spaces or formulas returning an empty string.
The result looks incomplete: Confirm that the source selection included the missing cells and that the destination had sufficient space. If the source contains merged cells, unmerge them and try again; merged layouts can interfere with copying and transposing.
Values appear, but the formatting is wrong: Undo immediately with Ctrl+Z on Windows or Command+Z on Mac if the paste just happened. Repeat the operation using the suitable Paste Special options, or apply the desired number format and borders to the result afterward.
Formulas show unexpected results: Inspect a few formulas in the destination. A copied formula can refer to different cells after being moved or transposed. If you wanted fixed results rather than calculations, paste values instead; if you need the formulas, correct their references deliberately.
You cannot edit or paste on the sheet: Check whether the worksheet is protected. If you have permission, use Review > Unprotect Sheet, then retry. If the workbook is shared or read-only, you may need an editable copy or access from its owner.

Frequently Asked Questions

Does “flip paste” mean the same thing as transpose?
Usually, yes. In Excel, the Transpose paste option swaps rows and columns. It does not rotate text, mirror a chart, or reverse the order of a list.

Can I transpose a row into a column without retyping?
Yes. Copy the row, click the first destination cell, and choose Home > Paste > Transpose. Excel places the row’s entries down a column in the same left-to-right order.

Will the original data change?
No. Copying and transposing leaves the source range in place. The destination is a separate pasted result unless you use a linked formula approach. You can remove the original later, after verifying the new layout.

Can I flip-paste formulas as well as values?
Yes, a regular transpose paste can include formulas. Because cell references may adjust when copied to a different position, inspect the formulas in the result. Choose a values-only paste if you need fixed displayed results instead of formulas.

Can I transpose a range inside an Excel table?
You can copy data from a table, but the destination must have a layout that can accept the pasted cells. If Excel blocks the operation or the result does not fit the table structure, paste the transposed range into a normal blank worksheet area first. Then decide whether to convert or arrange the result as a table.

Can I undo a transpose paste?
Yes, press Ctrl+Z on Windows or Command+Z on Mac soon after pasting. If you have made many later changes, undo may also reverse those changes, so check the workbook before continuing. Keeping the source range until the result is confirmed is a useful safeguard.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.