How to Copy Horizontal and Paste Vertical in Excel

Get FREE Advanced Excel Exercises with Solutions!

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.


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


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


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.


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.


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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo