Lesson#108: How to divert the user to another cell in workbook when clicked

Posted on Posted in Excel Features, Excel Tricks Tagged with
Lesson#108: How to divert the user to another cell in workbook when clicked

divert user to another cell Hi friend. Here I will show a method to divert a user to anywhere in the workbook when a link is clicked. For this, some steps are required.

Right-click on the cell where the link has to be created. Then click on Hyperlink as it has shown in the picture.

 

divert user to another cell

  1. Click on Place in This Document.
  2. Then click on the desired sheet number.
  3. Put the desired cell reference (Example: A1) below Type the cell reference.

 Your diverting link is prepared.

You may go through these posts also.

What is Hyperlink?
Lesson#101: Make hyperlink of all files and folders in worksheet within a minute
See also  Lesson#121: How to make some cells unprotected when protecting a sheet
About

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

9 Comments on “Lesson#108: How to divert the user to another cell in workbook when clicked”