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.
- 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?
Read More: How to Copy Paste Vertical to Horizontal in Excel
Similar Readings
- How to Copy and Paste Without Changing the Format in Excel
- Copy Rows from One Sheet to Another Based on Criteria in Excel
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.
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.
- 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.
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
- How to Copy and Paste a Column in Excel
- How to Copy and Paste Exact Formatting in Excel
- How to Copy Merged and Filtered Cells in Excel