Thread: [Solved] hyperlink jump to location
View Single Post
 
Old 01-10-2015, 08:56 AM
Gene2720 Gene2720 is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Apr 2013
Posts: 5
Gene2720 is on a distinguished road
Default hyperlink jump to location

I use hyperlinks to navigate to different locations in a single workbook, or different locations on the same work sheet. When I click the hyperlink and it jumps to the new location, the new active cell is always in the lower right hand corner (if out in the middle of the sheet) or in the lower left hand corner (if in the A column). Its like after the hyperlink jump I am presented the end of an area of information, not the beginning of the new area.
Is there a way to instruct Excel to present the active cell in the upper left hand corner of the screen upon the hyperlink jump?

Second question, Is there a way to specify a new hyperlink location in the same work sheet via a formula? in other words taking the current location and moving 22 cells down each time. I have a worksheet with 50 tables. I want to hyperlink a single cell in each table to create a "next button" that would move me to the next table. I know I can do this manually 50 times, but was hoping for (cell address +22 cells down) kind of formula in the new location bar.

Thanks....
Reply With Quote