Paste Special Options

There is another method of pasting the Values, without the formulas.

 

Before You Begin: Delete the data that you just pasted. We are going to start over.

 

5. Try it: Paste Special

Go to the Pigs spreadsheet.
Select Row 5 through Row 24.
(Do not include the Total in Row 25.)
Go to Home->Copy.

Go to a new spreadsheet, Sheet 2.
Select Cell A1.
Go to Home->Paste Special.

 

What Do You See? There are four rows of  Paste Options. You can choose whether to keep the formatting, formulas, or values.

 

What Else Do You See? The Other Paste Options include Paste Link, so you can link the data from one workbook or spreadsheet to another and synchronize the data.

Keep going, there's more. ;-)

Home->Paste ->Paste Special

 

Exam 77-882: Microsoft Excel 2010 Core

2. Creating Cell Data

2.1. Construct cell data: Paste Special