How to Copy Horizontal and Paste Vertical in Excel

While working in Microsoft Excel sometimes we need to copy horizontal data and paste them vertically to rearrange data. It might seem difficult to you but with proper technique, you can easily rearrange your data. Today in this article, I am sharing with you how to copy from horizontal and paste into vertical in Excel.

How to Copy Horizontal and Paste Vertical in Excel: 3 Easy Methods

In the following, I have described 3 quick and easy methods to copy horizontally and paste vertically in Excel.

Suppose we have a dataset with some “Fruit” and their “Price” in a worksheet. Now we will copy the table and paste it vertically. Stay tuned!

1. Use Paste Option

Microsoft Excel has a built-in feature to copy and paste data horizontally and vertically. We can do it using Paste options. Follow the instructions below to learn this simple technique-

Steps:

First, choose cells (B4:I5) and select “Copy” from the options.

Second, choose a cell (B7) where you want to paste your data.
Next, select “Transpose” from the “Paste” option.

In summary, you will get the result pasted vertically in the worksheet. Simple isn’t it?

2. Apply TRANSPOSE Function

If you want you can also use the TRANSPOSE function to change the orientation of your data table. The TRANSPOSE function converts a horizontal range of cells to a vertical range or vice versa.

Steps:

Start with, selecting cells (B7:C14) and put the below formula-

=TRANSPOSE(B4:I5)

Hence, click the CTRL + SHIFT + ENTER key.

In conclusion, we have successfully changed the orientation of the table.

3. Utilize Paste Special Feature

You can do it by using Paste Special command to copy horizontally and paste vertically in Excel. Follow the instructions below-

Steps:

Simply, select cells (B4:I5) and hit the CTRL + C button from the keyboard to copy.

Next, choose “Paste Special” from the “Paste” option.

In the new dialog box, checkmark the “Transpose” feature and hit OK.

Finally, the selected table is pasted vertically in Excel.

Things to Remember

You can also get the “Paste Special” dialog box by pressing the ALT + E + S key from the keyboard.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

Copy Horizontal and Paste Vertical.xlsx

Conclusion

In this article, I have tried to cover all the methods to copy horizontal and paste vertical in Excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience.