Paste Errors

4. What Else Do You See? Look next to the #REF! message:  There is an exclamation point that flags the error. This error has been identified as an Invalid Cell Reference.

 

The Error options include:

Help on this error

Trace Error

Ignore Error

Edit in the Formula Bar

Error Checking Options

 

This #REF! error comes from pasting data from one spreadsheet to another, but the new spreadsheet does not include all of the Cells that the formulas reference. Keep going...

Home->Paste

Exam 77-882: Microsoft Excel 2010 Core

2. Creating Cell Data

2.1. Construct cell data: Paste Special