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.
How to move cells from horizontal to vertical or vice versa?
