copy vertical data and paste it horizontally in excel

Copy vertical data and paste it horizontally in excel how to#

In the menu, “Paste Special” is listed after “Paste Options.” The “Paste” icon, which is a piece of paper on top of a clipboard, is also immediately beneath this button. Right-click the area and select “Paste Special” from the drop-down menu to accomplish this. Transpose the information after you’ve highlighted the new space for your cells. Excel can correctly transpose the data when the appropriate number of cells are chosen. As an illustration, if there are two columns with five cells each, you would highlight two rows with five cells each. Highlight the precise number of cells in your dataset using your mouse. Choose a location on your workbook thats empty. Next, select where youd like to paste the data vertically. Additionally, you can right-click on the cells and choose “Copy” from the menu 2. Copy the dataset once you’ve selected it by pressing “Ctrl” and “C” on your keyboard. Click and drag your mouse over the group of cells to select the ones you want to transpose.

Open the workbook containing your dataset in Excel by launching the program. To paste horizontal data vertically in Excel, follow these four steps: 1.

Copy vertical data and paste it horizontally in excel how to#

How to paste horizontal data vertically in Excel In the drop-down menu, (2) click on Paste Special, then (3) choose to Paste transposed. After that, (1) choose a cell where you want to paste the selected data range and right-click. Select the data you want to paste vertically, right-click it and then click on Copy (or use the CTRL + C shortcut).