View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default When double clicking on link in cell it doesn't go the cell.

Tools|Options|Edit tab
uncheck edit directly in cell.

Brian wrote:

I have links between worksheets in one particular workbook. Usually if you
double click on the link, you get linked to that particular cell. However,
when I double click it only shows the formula in the cell instead of linking
to the cell. How do I fix my worksheet to allow my to link when I double
click? Thanks.


--

Dave Peterson