You can transpose in Excel, turning rows into columns or the reverse, with a copy and a special paste. This guide walks through the steps from Microsoft's Excel for Mac support page. It also covers the two problems that trip people up most: Cut doesn't work, and Transpose is unavailable when your data sits in an Excel table.
Microsoft's example is a sheet with sales regions across the top and quarters down the side. Transpose swaps them, so the quarters run across the top and the regions run down the side.
Which versions these steps cover
Microsoft's page applies to Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac and Excel 2021 for Mac, according to the page itself. This article does not cover the Excel for Windows menus or Excel for the web, because the confirmed source covers the Mac only.
Flip rows and columns with Paste > Transpose
- Select the whole range you want to flip, including any row or column labels.
- Copy it. Click Copy on the Home tab, or press CONTROL+C. Do not use Cut.
- Click the first cell where you want the flipped data to start. Pick a spot with enough empty room, because the pasted data overwrites anything already there.
- On the Home tab, click the arrow next to Paste, then click Transpose.
- Check that the data rotated correctly. Once it has, you can delete the original range.
Why Cut doesn't work
Microsoft's note is blunt: you must copy the data, and using Cut or CONTROL+X won't work. If you cut first, start again: undo, select the range, copy it, then paste with Transpose. When you are happy with the result, delete the original yourself.
Fix: Transpose is greyed out
The usual cause is that your data is formatted as an Excel table. Microsoft says the Transpose feature isn't available for data in an Excel table. Convert the table to a normal range first:
- Click any cell inside the table.
- On the Table tab, click Convert to Range.
- Run the copy and Paste > Transpose steps above.
Microsoft also names the TRANSPOSE function as an alternative for table data, but converting to a range is the quickest way to get the paste method working again.
Check formulas before you rotate
If the range contains formulas, Excel updates them to match their new positions. Before you copy, make sure every formula in the range uses absolute references, and change any relative references to absolute ones, as Microsoft's page advises.
If you flip the same data often, use a PivotTable
Pasting with Transpose is fine for a one-time change. If you want to rotate data often to look at it from different angles, Microsoft suggests a PivotTable instead. You drag fields between the Rows and Columns areas, and the layout flips without any copying. Our PivotTable guide shows how to set one up.