Then copy the column by pressing Ctrl + C, and then click a cell to put the result, right click it, choose Pate Special from the context menu, see screenshot:ģ. Select the data column that you want to move to a row.Ģ. In Excel, there is also has an easy tool – Paste Special feature, it may help you to paste the data from vertical to horizontal or vice versa. Note: This formula also can help you to convert a horizontal row to a vertical column by just changing the cell reference. After pasting the formula, then press Ctrl + Shift + Enter keys together, and the cells in vertical have become horizontal row, see screenshot: In the formula bar, please paste this formula: =TRANSPOSE($A$1:$A$11), ( $A$1:$A$11 is the list that you want to convert to horizontal cells, you can change the cell reference to your need), see screenshot:ģ. Select the horizontal cells where you want to put the result. The following TRANSPOSE function can help you transpose the vertical cells to horizontal cells.ġ. Move cells from vertical to horizontal or vice versa with Kutools for Excel
Move cells from vertical to horizontal or vice versa with Paste Special
Move cells from vertical to horizontal or vice versa with formula How could you move cells from vertical column to horizontal row or vice versa quickly and easily in Excel? Supposing, you have a list of names in a worksheet, and now, you want to move the cells in that column to a horizontal row as following screenshot shown.
#EXCEL TRANSPOSE CELLS FROM HORIZONTAL TO VERTICAL HOW TO#
How to move cells from horizontal to vertical or vice versa?