Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2005

Tip: Looking for answers? Try searching our database.

Excel Hyperlink to Page Break Preview

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tkt_tang@hotmail.com - 30 Dec 2005 05:46 GMT
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@gmail.com - 30 Dec 2005 14:48 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.