software

I have 2 tabs, called quot;Sheet1quot; and quot;Sheet2quot;. On quot;Sheet1quot;, I have hundreds of
one line feature descriptions for my product. These descriptions are of
course text. On quot;Sheet2quot;, I have inserted hundreds of screenshots of my
product. Now comes the fun part...

I created a hyperlink on the first line of text on quot;Sheet1quot; to link to a
cell just above the corresponding image on quot;Sheet2quot;. When I click on the
hyperlink, I am taken to quot;Sheet2quot; and the cell i linked to is highlighted and
visible on the screen. The problem is that the cell is at the bottom of the
screen and the image I want to be displayed is below the bottom of the screen
and not visible.

I want whatever cell I hyperlink to, to be displayed at the Top of the
screen so that the image is fully on the screen every time, so that the user
just clicks a hyperlink and sees the corresponding image without having to
scroll up or down.

In HTML, browsers handle this automatically and display whatever you link to
at the top of the browser. Is there a way to ensure that whatever I link to
is moved to the same location (Top) every time?

Thanks in advance for any help i can get.

If the linked-to range is not just one cell but a large area, it will scroll
to the top left. For example, if you're linking to cell A25 on Sheet2, link
instead to A25:Z100 -- that will ensure A25 is at the top left of the
screen. Granted, all those cells will be selected, but all you'd need do is
press shift/backspace to reduce the selection to the active cell.
Bob Umlas
Excel MVPquot;twilliamsquot; gt; wrote in message
...
gt;I have 2 tabs, called quot;Sheet1quot; and quot;Sheet2quot;. On quot;Sheet1quot;, I have hundreds
gt;of
gt; one line feature descriptions for my product. These descriptions are of
gt; course text. On quot;Sheet2quot;, I have inserted hundreds of screenshots of my
gt; product. Now comes the fun part...
gt;
gt; I created a hyperlink on the first line of text on quot;Sheet1quot; to link to a
gt; cell just above the corresponding image on quot;Sheet2quot;. When I click on the
gt; hyperlink, I am taken to quot;Sheet2quot; and the cell i linked to is highlighted
gt; and
gt; visible on the screen. The problem is that the cell is at the bottom of
gt; the
gt; screen and the image I want to be displayed is below the bottom of the
gt; screen
gt; and not visible.
gt;
gt; I want whatever cell I hyperlink to, to be displayed at the Top of the
gt; screen so that the image is fully on the screen every time, so that the
gt; user
gt; just clicks a hyperlink and sees the corresponding image without having to
gt; scroll up or down.
gt;
gt; In HTML, browsers handle this automatically and display whatever you link
gt; to
gt; at the top of the browser. Is there a way to ensure that whatever I link
gt; to
gt; is moved to the same location (Top) every time?
gt;
gt; Thanks in advance for any help i can get.