What is meaning of $ in excel

M

Mike H

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
 
C

Chip Pearson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Embed the same Excel multiple times 0
Auto Fill Word Documents 4
Insert multiple objects at once ? 3
While working with word 2010, closed itself! 0
comments font size 1
Help on {=SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1))} 3
Excel --> Word 4

Top