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....

(First question only:) I don't use hyperlinks inside Excel much. (Actually I'm not sure I ever have, though I do it often enough in Word.) But when I experimented with it just now, the new active cell was in the upper left. Before I hit the link, the target sheet was several pages down from the top, and I made the target R13C2. I infer that Excel scrolled up to activate the new cell, and stopped once the new cell was visible. If I'm right, that implies that in your case the target sheet was active above the target cell, and had to scroll down.

...Further experimentation yields one solution for you: Set the target to a range, not a single cell. That causes Excel at least to scroll down enough to display the entire range. The entire range is selected, too, which may be a disadvantage....

Bob
Thanks for the response, That kind of makes sense that Excel scrolls until it encounters the new active cell. On mine with a new file, Excel still does the same thing presenting the new active cell in the lower left or right of the screen.
I create a hyperlinked index at the sheet beginning. Then I use the hyperlinks to jump to one of the 50 tables I reference, then combine the table info via pivot tables.
Having to scroll to move the table into view every time is just an annoyance. I can find the address in the lower right corner that corresponds to the table being in view, but that also is an annoyance. Changing the table size (inserting rows) changes the screen that is presented.