View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Double Click to see formula source data? Set up?

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
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Peo Sjoblom" wrote in message
...
Toolsoptionsedit, deselect edit directly in cell
Of course if you have it checked you will still get the source highlighted

--
Regards,

Peo Sjoblom


"gt" wrote in message
...
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!
--
gt