James,

The dollar Fixes the reference and makes it absolute so when its dragged it
doesn't change. You can fix the column

$F4

The row

F$4

or both

$F$4

The easiest way to enter the symbols is by tapping F4 when yoiu enter the
formula in the formula bar.

Mike



"james" wrote:

When do we use thedollar sign in a formula fro example What is thr difference
between
$H$56 and H56