How do I make hyperlink target scroll to the top-left of spreadshe

[Lori W.]

I can't remember the setting to make Excel automatically scroll my
hyperlinked cell to the top-left. For example, if my hyperlink is in cell A1
and the hyperlink destination is cell Z30, when you click the hyperlink in A1
the cell Z30 is now displayed in the top-left of the spreadsheet.

It seems like there was a checkbox in the Options dialog box, but now I
can't find it.
I did this awhile ago, but forgot to write down the information.

 

[Ron de Bruin]

Hi Lori

Tools>Options

On the Transition tab
Transition navigations keys

 

[Lori W.]

That was it!

Thank you.

Hi Lori

Tools>Options

On the Transition tab
Transition navigations keys

 

[GR]

Hi - Any idea where to find this setting for Excel 2007?

Thanks in advance

 

[GR]

Hi - Any idea where to find this setting for Excel 2007?

Thanks in advance

 

[GR]

Nevermind - I found the answer over here

http://www.techonthenet.com/excel/hyperlinks/hl_view2007.php