Excel Hyperlink to Page Break Preview

[tkt_tang]

1. Enter an Excel worksheet and set via pull-down menu, Windows >
Freeze Panes at Row 1.

2. Set Print Area and hence Page Break Preview ; then, the worksheet
shows multiple pages.

3. Enter a Hyperlink into Cell A1 and click to scroll to Page 2 thereof
(such that the worksheet scrolls down and the first row of Page 2 is
butting snuggly against Row 1 - which is frozen, remember ?)

4. After reaching Page 2 and then scroll down further ; say, page 3 and
beyond.

5. Click the Hyperlink in Cell A1 again. On the return flight, the
worksheet does not scroll into the position of Page 2 (despite that the
worksheet scrolls up and yet it does NOT show that the first row of
Page 2 is butting snuggly against Row 1 - and there, far from
expectation, it is out-of-view this time).

6. Please devise a Hyperlink such that when the worksheet is subject to
scroll from the upper and lower sides of Page 2, a Click will always
take the worksheet to home in at Page 2 (such that the worksheet
scrolls up or down and promptly, the first row of Page 2 is ALWAYS
butting snuggly against Row 1 of the worksheet).

7. Regards.

 

[Hoogwater]

A hyperlink will only set the active cell to the target of the
hyperlink, and bring the activecell into view. So that might be at the
bottom of the window, or at the top, dependent on where you come from.
You may accomplish what you want by looking at Custom Views.