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
 
Back
Top