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 What Do You See? Paste Special lets you choose what you want to paste. The default options include: All (everything), Formulas, Values, Formats, Comments, or Validation, only.   Options to Remove Formatting Paste Special can get rid of Formats, Themes, Borders or blanks you may have copied from the original sheet.   Operation Options You can select the operation you want to paste: Add, Subtract, Multiply, Divide, or None.   6. OK, Paste Something Select: Values and number formats. Click OK. The Rows of data will be pasted. There should be no errors. Keep going... Home->Clipboard->Paste ->Paste Special ->Values and Number Formats The Computer Mama sez: This can save you a lot of time!