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-
- 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 (2 Easy Ways)
- How to Copy and Paste Without Changing the Format in Excel
- Excel Formula to Copy Cell Value to Another Cell
- Copy Rows from One Sheet to Another Based on Criteria in Excel
- How to Copy a Worksheet in Excel (4 Smart Ways)
- Exchange (Copy, Import, Export) Data Between Excel and Access
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.
- Start with, selecting cells (B7:C14) and put the below formula-
- 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-
- 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.
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.
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.
- Use Paste Name Dialog Box In Excel (3 Ideal Examples)
- How to Copy and Paste Excel Table into Outlook Email
- Copy and Paste from PDF to Excel (3 Examples)
- How to Copy Cell If Condition Is Met in Excel (7 Easy Ways)
- [Fixed!] Cannot Copy Merged Cells in Excel (4 Solutions)
- Copy and Paste Exact Formatting in Excel (Quick 6 Methods)
- How to Copy the Same Value in Multiple Cells in Excel (4 Methods)