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

Embedded Excel into Word with Tables 0
Need Help with Macro Security 1
Found few bugs in my daily routine of work in excel for MAC 0
Set as Default Template not working 0
Found few bugs in my daily routine of work in excel for MAC 0
Dealing with the error: unable to filter on excel hc home school 0
Cell data entering slow! 0
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0

Top