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
 
You must log in or register to reply here.

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

Reference Cell Altering Formulas 1
Excel VBA 1
About references 1
automatically show cell references of formulas 2
How to reference workbook name in hyperlink formula? 1
2010 Format Questions Please 3
COUNTIF + ADDRESS Issue 1
hlookup with the sheet name is a reference from another cell 2

Back
Top