Paste Data with Special Results : Paste « Editing « Microsoft Office Excel 2007 Tutorial






Select A1 or a range. Click the Home tab. Then click the Copy button.
Select A1 or a range. Click the Home tab. Then click the Copy button.
Click A2 or another cell. Then click the Paste button. Then click Paste Special.
Click A2. Then click the Paste button. Then click Paste Special.
Click the option buttons with the paste results and mathematical operations. Click OK.
Click OK.
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