Hyperlinks

[beeemergyrl]

I'm creating a workbook where my first sheet has hyperlinks to various areas
withi the workbook. How do I creat a hyperlink where once the link is clicked
the linked cell will appear on the very top of the page? Righ now, when I
click on the hyperlink it will just go to the cell it is linked to without
bringing it to the top of the page. Please help. Thanks.

 

[JNW]

You can set the destination cell to be a range. so if you are trying to link
to A287 you can set the destination as A287:A350. This will select all of
these cells but the top cell in the select will be at the top of the screen.

I have seen spreadsheets that hide column A then link to the hidden column
so you don't see all of the selections.

 

[beeemergyrl]

JNW- Thanks for your reply. I've already selected the range for the hyperlink
however when the link is clicked it just highlights the selection and does
not bring it to the top of the page. Do you haved any suggestions? Thanks
again.

 

[JNW]

Looks like I forgot to mention that the range has to be bigger than the
visible vertical space on the screen. For me @85% zoom and a 19" widescreen
monitor placed in portrait that is at least 80 rows. Bad part is: you have
to account for screen sizes, resolution and zoom. You could always set it to
1000 rows.