Before copying the data, you need to convert the data range into a normal regular data range. How? If you select any of the cells in that table range, excel will open two more ribbons named “Table Design” and format. If your data range is in a table, you will know it.

Never use the “CUT” option or “Ctrl + X” option to cut your data and paste it vertically in excel.

Before pasting a data range, you need to copy the data range first.īut before copying the data, you need to remember something. This is the most used way to paste data vertically in excel.

How to Paste Vertically in Excel Using Paste Special (Transpose) Option We can copy and paste vertically in excel in 3 ways.

In this article, we will try to learn how to paste vertically in excel.

You can also copy comments in excel as well. Now, we want to copy those columns and paste vertically in excel all the data without any change. Now, you want to copy the data and paste vertically in excel in order to add some more rows under the data range.Īs we can see, we have our account managers’ names in one column and their 2015 sales in another. For a better understanding of your data, sometimes you need to convert or put your column data into a row or multiple rows and vice versa.įor example, you have a range of data where the account managers’ name and their sales in 2015 are in the rows or inserted horizontally. Excel has diversified ways of making your data easier to read and understand. Usually, when you are working in excel, you need to insert your data set in columns and rows.

How to paste list into excel cells