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

"Bob" <Bob @discussions.microsoft.com wrote in message
...
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.