Double Click to see formula source data? Set up?

G

gt

Does anyone know how to set your Excel to see the formula source data by
double clicking cell that contains the formula?

For example say cell B4 contains the formula =A4 + 10. If you double click
cell B4 it takes you back to cell A4 (since its source data). Do you know how
to set this up? I got a new computer this week and my Excel isn't
coorperating!
 
P

Peo Sjoblom

Tools>options>edit, deselect edit directly in cell
Of course if you have it checked you will still get the source highlighted
 
F

FSt1

hi,
i don't (by double clicking) but you have that available to you.
tools>formula auditing>trace precedents

Regards
FSt1
 
R

RagDyeR

You could *retain* the "Edit In Cell" functionality, and still move back and
forth between referenced formula cells by using:
<Ctrl> [
AND
<Ctrl> ]

--

Regards,

RD
 
Top