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. ;-)