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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 

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

Navigating between worksheets using the keyboard? 2
navigating between worksheets 3
Why Can't I navigate Excell 2003 Worksheets via Navigation Bar 3
Navigate between worksheets 1
Navigation Problems 1
Web-type Back and Forward navigation between Excel worksheets 3
Creating a template that I can reproduce every month by keying ininformation from SAP 8
Navigating between worksheets. 1

Back
Top