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

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