Hyperlinking

[RickM]

Hello, newbie here. I have created a list of names and gave each a hyperlink to an area in the spreadsheet in clouum "A". When I click on the link it takes me to where I want it to go, for instance A395, but it always shows up as the last line on the page. Is there any way I can get it to appear at the top? Thanks!

[starguy]

Hello, newbie here. I have created a list of names and gave each a hyperlink to an area in the spreadsheet in clouum "A". When I click on the link it takes me to where I want it to go, for instance A395, but it always shows up as the last line on the page. Is there any way I can get it to appear at the top? Thanks!

Hi Rick

when you are at top of the page and link cells which are at top of the page to any cells at below area, by clicking on the hyperlink it will take you to the linked cell but it will be at the last line.

when you are at below area and link cells which are at below area to any cell at the top of the page, by clicking on the hyperlink it will take you to the linked cell but it will be at the top line.

example:

if you create hyperlink in cell A1 to cell A500, by clicking on A1 it will show you A500 at last line of page.
but if you create hyperlink in cell A1000 to cell A500, by clicking on A1000 it will show you A500 at top of the page.

hopefully this will make you understand why are you getting the linked cell at the last line.
(infact it is Excel's default behaviour)

Regards.

[RickM]

Thanks for the explaination Starguy.