Exam 77-420 Microsoft Excel 2013 2. Create Cells and Ranges 2.1 Insert Data In Cells and Ranges: Copy and Paste Data (Paste Special)

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 28. (Do not include the Total in Row 29.) Go to Home->Clipboard->Copy. Go to a new spreadsheet, Sheet 2. Select Cell A1. Go to Home->Clipboard->Paste. Click on 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->Clipboard->Paste ->Paste Special