Microsoft Excel is a spreadsheet creator that allows you to enter data into columns and rows. When starting to create a spreadsheet with Excel, you may find that the spreadsheet doesn't look like you want it to because the columns or rows are in the wrong places. Instead of erasing the entire document and starting over from scratch, you can copy rows to columns.
Click on the row number, which is at the far left of the row. This selects the entire row.
Press on the "Ctrl" and "C" keys on your keyboard at the same time to copy the row.
Right-click in the top cell of the column into which you want to paste the data. Select "Paste Special."
Select "Transpose." Click on "OK." This copies rows to columns.
Tips & Warnings
- To select multiple rows or columns at once, hold down on the "Ctrl" key as you click on each column or row.
- Photo Credit number background image by kuhar from Fotolia.com
How to Convert Columns to Rows in VBA
Excel VBA (Visual Basic for Applications) requires no programming skills. Excel can record your keystrokes in an executable macro using the “Record...
How to Copy & Paste Large Columns of Data in Excel
The copy and paste function within Microsoft Office is useful, but when pasting data into Excel it is important to prepare the...
How to Copy & Paste Row Height in Excel 2007
Copying formatting from one row to another can be a time-saver. If you have spent time adjusting a particular row to the...
How to Sum a Column or Row of Excel Cells
Sum columns or rows in an Excel spreadsheet by highlighting the row or column and clicking auto sum. Add columns or rows...