Hyperlinking within the same worksheet

S

sojourn12

This may be trivial, but I'd love to know how to do it.

I have a large worksheet and I am using hyperlinks to connect the cells
in the main area of my worksheet to explanatory data in the
netherlands. I go to the netherlands and I "name" the explanatory data
section. I then go to the main area and hyperlink a cell to the
"named" section. It works fine.

The only problem I have is that when my hyperlink opens the "named"
area, the first cell in the named area appears in the very lower right
hand section of my display. Is there any way I can have it appear in
the upper left (all of my explanatory data fit on one screen, so it
would work really well if I could figure it out). When I am "naming,"
I make sure the the first cell is in the upper left before I press
enter, but that doesn't seem to work. Thanks ever so much. I
appreciate it.
 
Top