Hyperlink to center screen in the selected cell

Newbie73

Board Regular
Joined
Feb 4, 2024
Messages
116
Office Version
  1. 365
Platform
  1. Windows
Hello everyone, I have a few hyperlink cells with the following formula:

Excel Formula:
=IFERROR(HYPERLINK("#Main!"&ADDRESS(MATCH(Summary!D22,Main!$C$1:$C$50001,0),2),"Test"),"")

It basically takes me to a different sheet with the same cell value as D22 on the current sheet.

It works perfectly, but is there a way to make it center on the selected cell? As it is now, it takes me to the correct cell but just at the border of the screen (which can be up or down) and it can be hard to spot the selected cell.

Thanks
 
Do you mean, scroll down/right/up/left itself destination sheet to make selected cell in center of screen, right?
 
Upvote 0
Hello KOKOSEK, yes scroll down and up, right and left isn’t necessary as the columns are usualy within B and E, I have loads of those hyperlink (including in different sheets) but all follow the same formula. It’s just a shame it’s hard to see the highlighted cell, would be much easier to spot if it was in the middle of the screen
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top