Thread: Double Click to go to source
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Double Click to go to source
ButtonExcel OptionsAdvancedEditing Options.

Uncheck "allow editing directly in cell".


Gord Dibben MS Excel MVP

On Fri, 19 Mar 2010 03:14:01 -0700, Mand101
wrote:

In my previous version of Excel there was an option to double click on a
linked cell and Excel would then take you to that cell or the source data if
it was a poivot, how do I do this in Excel 2007?

Reply With QuoteReply With Quote