doubleclick in cell to open link - how

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Used to work with Excel 2003 and went in option and changed the setting there
- how to this in 2007 excel
 
Click on the office button, and at the bottom of the pop-up click "Excel
Options". Under "Advanced" there's a tick box for "Allow editing directly in
cells", make sure this is un-ticked.
 
Excel 2003 has no function that would open a link with a double-click.

You can double-click in a cell to enter edit mode if your
Tools>Options>Edit>"edit directly in cell" is enabled.

If you have that disabled, a double-click will send you to cells referenced by a
formula in that cell.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Linked cell shows ###### 5
#N/A In Cells 7
How do I get Rid of the Circumflex Accent (Caret) 2
Adding days to a date - changed in Excel 2010 8
Link To File That No Longer Exists 1
Automatic Go to 0
how do I get color to show on desktop 1
Unprotect 2003 excel files when opening in Excel 2007 1

Back
Top