Double Click to see formula source data? Set up?

G

Guest

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
 
G

Guest

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
 

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

Double Click to go to source 1
Use first day of month formula in a drop down list 3
Capturing Trend Data over time 1
Display only unique values in CONCATENATE formula 4
excel "IF" formula... if this possible ??? 0
Help on formula 2
double click cell to show formula references 1
Formula Help - If and Subtotal(???) 4

Top