How to Paste from Horizontal to Vertical in Excel 2013

Many times when working with data in Excel I am not positive how I will need to organize the data. I am hoping that my first guess is correct but, sometimes, I find that a different layout would be more effective. If I have already entered a lot of data, then I may be looking for a way to avoid having to do that data entry again.

One way that you can fix this problem, if your data is currently in a row and you need it to be in a column instead, is to paste that horizontal data into a vertical layout. This is accomplished with a Paste option called Transpose, and it can really be a time saver. So continue reading our article below to see how you can paste from horizontal to vertical in Excel 2013.


How to Copy a Row of Cells and Paste Them Into a Column in Excel 2013

The steps in this article were performed in Microsoft Excel 2013. However, these will also work in Excel 2010 and Excel 2016. Note that this will work best if you are pasting into empty cells. Otherwise you may lose the data in the cells where you are pasting your copied data.

Step 1: Open your spreadsheet in Excel 2013.


Step 2: Select the horizontal cells that you would like to paste vertically.

select horizontal data



Step 3: Right-click the selected cells, then choose the Copy option. Note that you can also press Ctrl + C on your keyboard to copy instead.

copy the original horizontal data



Step 4: Click in the cell where you wish to display the first vertical cell.

click inside the top cell where you want the vertical cells



Step 5: Click the Home tab at the top of the window, then click the small arrow under the word Paste.

open the excel 2013 paste menu



Step 6: Click the Transpose option on the Paste dropdown menu.

how to paste from horizontal to vertical in excel 2013



Step 7: If the cells are now displaying how you would like them to, you can right-click the original horizontal data, then click the Clear Contents option to delete it without affecting the layout of the rest of the spreadsheet.

clear contents of original cells


Are you having trouble getting your spreadsheet to print properly? Read our guide on Excel print optimization for some tips and tricks that can help you to solve the frustration that you might be experiencing.