Hi,

it makes a cell reference 'absolute' i.e. if you drag the formula the range
doesn't change'

there are 4 options

=A1 - Row and column relative
=$A1 - Row relative column absolute
=A$1 - Row absolute column relative
=$A$1 - Row and column absolute

The easy way to change these id when you enter a range into a formula tap F4
and you will see the range change. tap a second time for the next option etc.

Try the formula above in a sheet and drag them into new cells and you'll see
practical examples.

Mike

"Sandeep Jangra" wrote:

Dear all
Plz help, what is meaning of $ in excel