Use of $ symbol while writing a formula?

P

PCLIVE

$ makes your reference constant. For example, if in A1 you have =B1 and
then you copy cell A1 and paste it in A2, your formula will automatically
incriment, therefore being =B2.
In order to make what you paste refer to the same reference, your formula
would have to be =$B1. A $ before the B will maintain your column reference
as "B" regardless of where you copy and paste the formula to. To also
maintain the row reference, you would need a $ next to the number as well.
Ex. =$B$1

You should be able to find help topics in Excel for this.

HTH,
Paul
 
D

David F Cox

if you copy this
=$A$1
down you will find each cell still points to A1
The $ fixes the part of cell reference following
 
Top