Formula cell references

  • Thread starter Thread starter Ray K.
  • Start date Start date
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
 
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
 
Back
Top