How Do I Copy a Row in Excel & Paste it Into a Column?

Microsoft Excel is the spreadsheet software program that is part of the Microsoft Office suite. Different versions are available for both Windows and Mac, though all versions work similarly. Excel is suited for analyzing data in different ways, automating tasks with the built-in macro software and producing graphs and other table analysis. Learning how to copy a row and paste it as a column, or vice versa, is easy using the Paste Special function.

Step

Click the row or column that you want to copy, for example row "2."

Step

Right-click the first cell in either the row or column you want to paste your data in.

Step

Click the tick box for "Transpose" in the bottom right of the window. Click "OK."