You may have observed in Microsoft Office Excel; you can copy or move the cells, rows, columns, or ranges at your convenience. However, there appears to be no trick available for swapping the same. Not anymore! Excel, if you are not aware, supports a one-click operation to quickly swap rows, columns, or ranges, known as ‘Transpose‘.
The feature works with all recent versions of Microsoft Excel, including Office 365.
Transpose feature in Excel
Here, if you see, I have created a spreadsheet in Excel in vertical orientation using a column style. We will proceed further and change the same into a horizontal row style. Here’s how.
From your Excel sheet, select the desired cells you would want to change.
Once done, Right-Click and select the ‘Copy’ option.
Next, right-click on an empty cell and choose Paste Options > Transpose, as shown in the screen-shot below.
One of the highlights of Excel is that it will show you a preview of what the paste would look like before confirming the action.
If you do not see it, as an alternative step, you can Right-Click an empty cell and select ‘Paste Special’.
Then, from its window, you can check the ‘Transpose’ box and click OK.
You will now see your data transposed to a new layout style.
The same feature allows you to convert horizontal row data sheets into vertical column style sheets too.
How do you transpose a cell to a zero in Excel?
If you need to convert all blank cells to zeros, then use the Transpose feature to convert. It comes in handy when you have too many blanks in a row or column that would take a lot of time to fill. Instead, using transpose automatically filled blanks to zeros.
How do you transpose text in Microsoft Office?
If you mean to convert horizontal text to vertical, select the text, and click on the Alignment section under Home Tab. Select the Vertical option text, and it will transpose within the same cell.
How do I change the order of columns in an Excel spreadsheet?
If you need to move a column to left or right or anywhere in the Excel file, then it’s simple. First, you need to select the column by clicking on the header of the column. Then press the Shift key, and hover the mouse pointer to one of the sides. You can then drag and move it anywhere you want. Makes sure not to release the Shift key.
