What is meaning of $ in excel
 

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

What is meaning of $ in excel
 

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

What is meaning of $ in excel
 

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