How to Copy Rows to Columns

Save

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.

References

  • Photo Credit number background image by kuhar from Fotolia.com
Promoted By Zergnet

Comments

Resources

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!