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
Step 2:
Right-click on a new position on that Excel spreadsheet and select Paste Special ...
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
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
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.