Comma Training Page 59

Paste Special: Values

7. Try it: Paste the Sample Data

Go to the Eggs spreadsheet.
Select Row 1 through Row 20.
(Do not include the Total in Row 21.)
Go to Home->Copy.
Go to the new spreadsheet, Sheet 2.
Select Cell A21. Go to Home->Paste Special->Values and number formats..

Go to the Legs spreadsheet.
Select Row 1 through Row 20.
Go to Home->Copy.
Go to the new spreadsheet, Sheet 2.
Select Cell A40. Go to Home->Paste Special->Values and number formats.

Try This, Too: Rename the spreadsheet

Double-click the tab for this spreadsheet. Type: Original Data for TEXT Formulas.

8. Try This: Save the Spreadsheet

Go to File->Save.

Go to your Documents folder, if you wish.

Type the Name: Counting Chickens 2010.

Click on SAVE.