Excel: Sounds Good Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 More

Paste Between Worksheets What Do You See? When you copy and paste rows into a new spreadsheet, you may see an error message; #value! That's Excel's way of asking, "Where's the data?"   Try it: Copy and Paste the Rows Open the sample workbook. Go to the Eggs spreadsheet. Copy the rows for February and March.   Go to the new spreadsheet. Select the next blank cell in the A Column. Paste the rows.   #value! Click on any cell that says #value! and you will see that the equations are still there. For example, these images show: D41=D40+$B$3   When you paste formulas into a new spreadsheet the cell references may became meaningless. In this example $B$3 has text, not numbers. How do you add text to numbers? #value! Home->Paste