ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hyperlink to top left cell (https://www.excelbanter.com/excel-discussion-misc-queries/172641-hyperlink-top-left-cell.html)

GR

Hyperlink to top left cell
 
Hi - I am having the same problem as Lori except in Excel 2007. Any
suggestions?

Thanks



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

Hyperlink to top left cell
 
Nevermind - I found the answer over he

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

"GR" wrote:

Hi - I am having the same problem as Lori except in Excel 2007. Any
suggestions?

Thanks



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:54 PM.

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