Excel 2010 In Pictures

Employ absolute references

1 On the Revenue sheet, click cell B4.

Notice the formula in the Formula Bar:

='Numbers Per-Frog'!E8*Sales!A4