What is meaning of $ in excel

  • Thread starter Thread starter Sandeep Jangra
  • Start date Start date
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
 
The '$' character tells Excel not the adjust the column reference, the
row reference, or both, when you copy/paste or fill a range.
Typically, if you enter =A1 and Fill down, Excel will change the
formula to =A2, then =A3, then =A4 and so on down the filled range.
The '$' character tells Excel not to adjust the reference. Thus, if
you fill down the formula =A$1, all the cells will have that same
formula since Excel doesn't adjust it.

See http://www.cpearson.com/Excel/relative.aspx for more info about
absolute and relative references.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
The San Diego Project Group, LLC
(email is on the web site)
USA Central Daylight Time (-5:00 GMT)
 
Back
Top