Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I make the scroll bar show the row number? | Excel Discussion (Misc queries) | |||
Can you make a Excel hyperlink connect to an outlook address card | Excel Discussion (Misc queries) | |||
how to make column titles float with the scroll bar | Excel Discussion (Misc queries) | |||
how to make number as text and left justified? | Excel Worksheet Functions | |||
how do I make the left margin of a header the same as the page ma. | Excel Discussion (Misc queries) |