Paste Cells from Rows to Columns or Columns to Rows : Paste « Editing « Microsoft Office Excel 2007 Tutorial






Select A1 to A5. Click the Home tab. Then click the Copy button.
Click the Home tab. Then click the Copy button.
Click B1. Then click the Paste button arrow. Then click Transpose.
Then click Transpose.
Check the result.
Then click Transpose.
2.6.Paste
2.6.1.Paste Data with Special ResultsPaste Data with Special Results
2.6.2.Paste Cells from Rows to Columns or Columns to RowsPaste Cells from Rows to Columns or Columns to Rows