Jump to link worksheet

[Guest]

Is there a function in an excel where you double click the formula which is
linked to another worksheet and it open the worksheet automatically?

Thanks to let me know.

Dinesh

 

[Guest]

You can use the HYPERLINK function or else you can use the menus:
Insert--Hyperlink. If you use the latter method, you want to select workbook
hyperlinks, not internet hyperlinks from the dialog box. The advantage to
using the menus is that the dialog box makes it clear what to choose. I find
the syntax of the HYPERLINK function confusing to remember.

Dave

 

[Gord Dibben]

Yes.

If you go into Tools>Options>Edit and uncheck "edit directly in cell".

Now double-click on the cell with the formula to jump to the source worksheet.

Or open the source workbook if that is what you mean.


Gord Dibben MS Excel MVP