How do you copy a row in Excel?

To copy data in rows in a spreadsheet into columns, or data in columns into rows, do a regular copy. Go to the start of where you want to put it and then go to the Edit menu, pick Paste Special and click Transpose and then click OK.