Double Click to go to source

M

Mand101

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?
 
G

Gord Dibben

Button>Excel Options>Advanced>Editing Options.

Uncheck "allow editing directly in cell".


Gord Dibben MS Excel MVP
 

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 see formula source data? Set up? 3
AutoFill double click does not work in Excel 2007 3
Double Click to go to precedent 2
How to I format a cell to display the link 1
Formula Linking Issue 1
Excel 2007 pivot table source table 1
Double Click Cell with link should take you directly to source 1
linked cells 1

Top