Formula writing problem

B

Bob

I am looking for the operator that works like the dollar sign inLotus 123 in
front of cell value so that the value doesn't change when the formula is
copied.
 
P

Paul B

Bob, =$A$1, to lock both column and row

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
C

CLR

$A$1 is an absolute reference to cell A1..........it will not change when
used in a formula and copied around.

Vaya con Dios,
Chuck, CABGx3
 
Top