How to Transpose in Excel: Flip Rows and Columns (2026)

You build a table with the months running down the side, then realise it would read far better with the months across the top. Before you retype anything, stop. Excel has a built-in way to flip rows and columns, and it takes seconds. It's called transposing, and it's one of those tricks that quietly saves an afternoon.

I've followed Microsoft's help pages here, so the steps and warnings are theirs, not guesswork.

What it means to transpose data in Excel

Transposing rotates a block of data so that what was in rows ends up in columns, and the other way round. The first row becomes the first column, the second row becomes the second column, and so on. Think of turning a table on its corner.

There are two routes. Pasting with the Transpose option gives you a fixed copy. The TRANSPOSE function gives you a live version that follows the original. Which one you want depends on whether the source is going to change.

Transposing in Excel with right-click paste

This is Microsoft's main method, and it's the one most people need.

1. Select the range you want to flip, including its row or column labels.
2. Copy it. Microsoft is clear that cutting won't work, so use copy.
3. Choose a destination with plenty of empty space, and right-click the top-left cell where the new table should start.
4. Under Paste Options, choose Transpose (T).

Once the new table looks right, you can delete the original and the rotated copy stays intact. Do check the destination first. Microsoft warns that the pasted table overwrites any data and formatting already there.

Transposing in Excel from the Home tab

If you prefer the ribbon to the right-click menu, Microsoft gives this route too. Copy the cells, select the empty cells where the rotated data should go, then on the Home tab click the Paste icon and select Transpose Rows and Columns.

Menus vary by version and by device. On a Mac, Microsoft's help places the Transpose option under the Paste menu on the Home tab, so look there if the right-click route isn't showing.

Using the TRANSPOSE function to flip a table in Excel

The function version is written like this, with your own range inside the brackets:

=TRANSPOSE(A1:B4)

Microsoft explains that the output area must have the rows and columns swapped. A source that is two columns wide and four rows tall needs a destination that is four columns wide and two rows tall. How you enter it depends on your version:

• Microsoft 365 with dynamic arrays: type the formula in the top-left cell of the output and press Enter.
• Older versions: select the whole output range first, type the formula in its top-left cell, and press Ctrl+Shift+Enter. Excel adds curly brackets around the formula for you.

The big difference is that TRANSPOSE gives live results. If a source cell changes, the rotated version updates too. Microsoft adds that a plain Transpose paste creates a duplicate that doesn't update, and that it's the better choice when you need the formatting to come along.

Question	Paste with Transpose	The TRANSPOSE function
Updates when the source changes?	No	Yes
Carries formatting across?	Yes, as Microsoft describes	Not the aim of the function
Works on an Excel table?	No	Yes
Needs Ctrl+Shift+Enter?	No	Only in older versions

When Excel won't transpose your table

The most common snag is that your data is formatted as an Excel table. Microsoft says the Transpose feature isn't available for data inside a table. You have two ways round it: convert the table to a range first, or use the TRANSPOSE function instead.

Here's a quick checklist if the option looks greyed out or the result is wrong:

1. Did you copy the cells rather than cut them?
2. Is the data inside a formatted table? If so, convert it to a range.
3. Is there enough empty space at the destination, with the shape swapped?
4. Did you right-click the top-left cell of the destination, not a cell in the middle?
5. Are you using the function in an older version without Ctrl+Shift+Enter?

Checking formulas after you transpose in Excel

If your data contains formulas, Excel updates them to match their new positions. Microsoft recommends checking whether they use absolute references before you rotate. If they don't, switch between relative, absolute and mixed references first, otherwise a formula can end up pointing at the wrong cell.

In a pinch, keep a copy of the original sheet and compare a couple of totals before and after. It takes a minute and protects you from a bad surprise in a client report.

Transposing in Excel when you only reshape now and then

Microsoft also points out that if you flip data often, a PivotTable can be easier, because you drag fields between the Rows and Columns areas instead of repeating the copy and paste. For a one-off layout change, though, paste with Transpose is quicker.

If your team keeps its numbers in Google Sheets, the idea carries over, and I've written about sorting a list in Google Sheets too. And if you'd like an assistant to help with formulas inside the workbook, here's Claude for Excel and how to install it.

Everyday jobs for a transposed Excel table

• Turning a column of monthly results into a row that matches your report layout.
• Rotating a survey export so each respondent is a row instead of a column.
• Flipping a content calendar so dates run across the top.
• Reshaping a list of product codes to fit a template that expects columns.

Frequently asked questions

How do I transpose in Excel?

Copy the range including its labels, right-click the top-left cell of an empty destination, and under Paste Options choose Transpose. Delete the original once the new table looks right.

Why can't I transpose my data in Excel?

Microsoft says the Transpose feature isn't available for data in an Excel table. Convert the table to a range first, or use the TRANSPOSE function. Also make sure you copied rather than cut.

What is the difference between Transpose paste and the TRANSPOSE function?

A Transpose paste makes a fixed copy that doesn't update. The TRANSPOSE function returns live results that change when the source cells change.

Do I need Ctrl+Shift+Enter for TRANSPOSE?

Microsoft says you do in older versions of Excel, after selecting the output range. In Microsoft 365 with dynamic arrays you type the formula in the top-left cell and press Enter.

Will transposing change my formulas?

Excel updates formulas to match their new placement, but Microsoft advises checking that they use absolute references first so nothing points at the wrong cell.