Share this article
Improve this guide
How to switch columns and rows in Excel [Swap / Transpose]
3 min. read
Updated onSeptember 25, 2024
updated onSeptember 25, 2024
Share this article
Improve this guide
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
People interpret data differently; some insert data horizontally and others prefer to do it vertically. For flexibility, MicrosoftExcelcomes with the Transpose feature, which lets you switch columns and rows inExcel.
The Transpose function inExcelchanges your columns and rows’ orientation. It allows you to perform this operation in two different ways – either with the paste options or by using a formula.
What is the best practice to switch the columns and rows in a range in Excel?
If you are working with an Excel file with lots of headings stacked horizontally, it gets clumsy to read or edit.
To switch the columns and rows inExcel, you have to either use paste options in the program or go with a formula as explained in this guide.
How can I change columns to rows in Excel?
1. Use paste and Transpose
2. Use the Transpose function in a formula
Speaking of rows, we also have an article that explains what to do if youcan’t insert a row in Excel, so don’t miss it.
Before you leave, don’t miss our guide on how toget data from another sheet in Excelfor more useful information.
Note:In the above formula,A1is the starting cell andF7is the ending one in the range. This technique makes use of an array and formula. Unlike the first method, switching columns and rows with this method can ruin the formatting.
More about the topics:Excel
Vlad Turiceanu
Windows Editor
Passionate about technology,Windows, and everything that has a power button, he spent most of his time developing new skills and learning more about the tech world.
Coming from a solid background in PC building and software development, with a complete expertise in touch-based devices, he is constantly keeping an eye out for the latest and greatest!
User forum
0 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Vlad Turiceanu
Windows Editor
Coming from a solid background in PC building and software development, he’s a Windows 11 Privacy & Security expert.
