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.


Download Practice Workbook

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


3 Easy Methods to Copy Horizontal and Paste Vertical in Excel

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. This paste option is known as transpose. Follow the instructions below to learn this simple technique-

Steps:

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

Use Paste Option to Copy Horizontal and Paste Vertical in Excel

  • 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?

Use Paste Option to Copy Horizontal and Paste Vertical in Excel

Read More: How to Copy Paste Vertical to Horizontal in Excel (2 Easy Ways)


Similar Readings


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.

Apply TRANSPOSE function to Copy Horizontal and Paste Vertical in Excel

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

Apply TRANSPOSE function to Copy Horizontal and Paste Vertical in Excel

Read More: Formula to Copy and Paste Values in Excel Automatically


3. Utilize Paste Special Feature

You can also utilize the paste special feature 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.

Utilize Paste Special Feature to Copy Horizontal and Paste Vertical in Excel

  • 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.

Utilize Paste Special Feature to Copy Horizontal and Paste Vertical in Excel

Read More: VBA Paste Special to Copy Values and Formats in Excel (9 Examples)


Things to Remember

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

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. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.


Related Articles

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo