Excel 2007 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