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

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.

See also  Lesson#84: Separate text in different columns easily

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