ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I make hyperlink target scroll to the top-left of spreadshe (https://www.excelbanter.com/excel-discussion-misc-queries/52606-how-do-i-make-hyperlink-target-scroll-top-left-spreadshe.html)

Lori W.

How do I make hyperlink target scroll to the top-left of spreadshe
 
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

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

ToolsOptions

On the Transition tab
Transition navigations keys


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Lori W." <Lori wrote in message ...
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.




Lori W.

How do I make hyperlink target scroll to the top-left of sprea
 
That was it! :-)

Thank you.


"Ron de Bruin" wrote:

Hi Lori

ToolsOptions

On the Transition tab
Transition navigations keys


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Lori W." <Lori wrote in message ...
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.





GR

How do I make hyperlink target scroll to the top-left of sprea
 
Hi - Any idea where to find this setting for Excel 2007?

Thanks in advance


"Lori W." wrote:

That was it! :-)

Thank you.


"Ron de Bruin" wrote:

Hi Lori

ToolsOptions

On the Transition tab
Transition navigations keys


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Lori W." <Lori wrote in message ...
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.





GR

How do I make hyperlink target scroll to the top-left of sprea
 
Hi - Any idea where to find this setting for Excel 2007?

Thanks in advance

"Lori W." wrote:

That was it! :-)

Thank you.


"Ron de Bruin" wrote:

Hi Lori

ToolsOptions

On the Transition tab
Transition navigations keys


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Lori W." <Lori wrote in message ...
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.





GR

How do I make hyperlink target scroll to the top-left of sprea
 
Nevermind - I found the answer over here

http://www.techonthenet.com/excel/hy...l_view2007.php

"GR" wrote:

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

Thanks in advance


"Lori W." wrote:

That was it! :-)

Thank you.


"Ron de Bruin" wrote:

Hi Lori

ToolsOptions

On the Transition tab
Transition navigations keys


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Lori W." <Lori wrote in message ...
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.





All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com