Formula cell references

R

Ray K.

When you double click on a formula that references other cells you usually
see the referenced cells outlined in a color with reference to that same
color in the formula. What is this called and is this something you can
turn on and off? Where?
Thanks

RLK
 
R

RagDyer

It's called "Edit In Cell".
You get exactly the same results when you click in the formula bar.

If you turn this off, double clicking in a cell containing a formula will
then make the focus move to the cell(s) referenced in the formula.

<Tools> <Options> <Edit> tab,
Check or uncheck "Edit Directly In Cell".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

When you double click on a formula that references other cells you usually
see the referenced cells outlined in a color with reference to that same
color in the formula. What is this called and is this something you can
turn on and off? Where?
Thanks

RLK
 
Top