Convert columns to rows and convert rows to columns in Excel

OctaFX Broker No Swap, Top 1 Malaysia, Indonesia
IQ Option Top 1 binary option, Give $10,000 demo account
Vultr VPS Start $2.50/month. Give $100 today
Nord VPN Get 70% off

Converting a row to a column or a column into a row is one of the fairly simple Excel tricks, but not everyone can do it right away. On the Excel spreadsheet application, there are many attractive features to support users with spreadsheet operations. Excel as a versatile accounting tool can help people calculate numbers from simple to complex in a very specific way. Therefore, Excel is always an indispensable office application when we want to perform the recording and calculation of data.

Download Microsoft Office 2016 for Windows Download Microsoft Office 2016 for Mac

In the previous articles, we have shown you a lot of cool tricks such as playing snake game on Excel, seniority, separating the name column , etc. There are many attractive features that surely no one can exploit when using Excel, Download.com.vn and you will discover each useful feature to serve your work.

How to convert rows to columns and vice versa in Excel

Step 1:

Highlight your entire previously created table in Excel and press Ctrl + C or right click -> Copy .

Copy the created spreadsheet on Excel
Copy the created spreadsheet on Excel

Step 2:

Right-click on a new position on that Excel spreadsheet and select Paste Special ...

Paste the created table in a special way
Paste the created table in a special way

Immediately after the small Paste Special window appears, select the Transpose -> OK .

Selecting the paste type converts the row into a column
Selecting the paste type converts the row into a column

Next you will see a new table that has changed columns to rows and vice versa.

The results have been converted to columns and vice versa
The results have been converted to columns and vice versa

Video tutorial on converting rows to columns in Excel

Above we have instructions on how to convert columns to rows in Excel. Hopefully this guide will make it easy for everyone to make changes to your created spreadsheet.

OctaFX Broker No Swap, Top 1 Malaysia, Indonesia
IQ Option Top 1 binary option, Give $10,000 demo account
Vultr VPS Start $2.50/month. Give $100 today
Nord VPN Get 70% off


Domain names for just 88 cents!