How do I navigate on a click between linked worksheets in Excel?

[Animesh]

How do I navigate on a click between linked worksheets in Excel?

 

[Gord Dibben]

Tools>Options>Edit.

Uncheck "edit directly in cell".

Now when you double-click on a linked cell, you will switch to the source
worksheet.

Won't go back to original linked cell.

It's a one-way street.

Alternative..........

In an unused cell enter a hyperlink to the linked sheet.


Gord Dibben Excel MVP