What Do
You See? When you
copy and paste data into a new spreadsheet, you may see many error
messages. That's Excel's way of asking, "Where's
the data?" 2. Try
This: Review the #REF Errors Click on any cell that says
#REF! You
will see that the formulas are still there. This example shows:
D3=D2+$B$3. When you
paste formulas into a new spreadsheet, the cell references may become
meaningless. In this example, there is no Reference Cell,
$B$3, so there is nowhere to look up the
quantity.
3. Try This: Review the #VALUE! Errors Click on any cell that says #VALUE! You
will see that the formulas are still there. This example shows:
E3=C3+D3. In this example
C3 has Text, not Numbers. How do you multiply Text times Numbers?
Hence, the error #value! Keep
going, please...
Home->Paste
Exam 77-882: Microsoft Excel 2010
Core
2. Creating Cell Data
2.1. Construct cell data: Paste
Special |
|
| |
