Open link by double clicking

[madeche]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Does anyone know how to open a link (a reference to another worksheet or or jump to another location within the same sheet) by double clicking the cell. I used to do it all the time on a PC. Also, anybody know the equivalent of F2 on a Mac (to go directly to edit the formula)
Thanks

 

[JE McGimpsey]

Does anyone know how to open a link (a reference to another worksheet or or
jump to another location within the same sheet) by double clicking the cell.

Choose Preferences/Edit, uncheck the "Double-click allows editing
directly in the cell"

I used to do it all the time on a PC. Also, anybody know the equivalent of F2
on a Mac (to go directly to edit the formula)

If you look at XL Help ("Excel Keyboard Shortcuts") you'll find:

Edit the active cell and position the insertion CONTROL+U
point at the end of the line

 

[madeche]

Thanks!