Formula writing problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
$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
 

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

SUMPRODUCT formula I think w/ wild card & number vs number as text 8
With F1 value, look at A, if match or partial match return B 5
Incrementing Formula by Column Instead of by Row 1
Convert number to text as displayed 3
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
Lookup function to cell containing multiple values 3
count 3
Formatting issue 2

Back
Top