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)


On Sat, 11 Oct 2008 00:40:00 -0700, Sandeep Jangra
wrote:

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