Hyperlinks or something

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 sheets (sheet one and Sheet two)
On sheet ONE in col A I have a number of entries
I want to be able to click on any one entry in sheet ONE and be taken to a
brief explanation on Sheet TWO.
Once on sheet TWO I would like to return to the starting point on Sheet ONE
Ex:
I cliick on A12 in Sheet ONE, that would take me to Sheet TWO a50
Once I have read the explantion on sheet TWO I would click on A50 in sheets
TWO and return to sheet ONE a12
One complication is that the entries on sheet ONE will not ALWAY be in the
same location due to a sorting process.
I would appreciate any help you can give me
Thanks
 
The Hyperlink item on the Insert menu does what you want.
Select the cell for the hyperlink to appear in and click the menu item.
A box opens with big buttons of the left side.
Click the one that says "Places in this document".
In the big white box, select the destination sheet.
In the small box above it select the particular cell.
Click OK.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"pcor" <[email protected]>
wrote in message
I have 2 sheets (sheet one and Sheet two)
On sheet ONE in col A I have a number of entries
I want to be able to click on any one entry in sheet ONE and be taken to a
brief explanation on Sheet TWO.
Once on sheet TWO I would like to return to the starting point on Sheet ONE
Ex:
I cliick on A12 in Sheet ONE, that would take me to Sheet TWO a50
Once I have read the explantion on sheet TWO I would click on A50 in sheets
TWO and return to sheet ONE a12
One complication is that the entries on sheet ONE will not ALWAY be in the
same location due to a sorting process.
I would appreciate any help you can give me
Thanks
 
Yes that is true...but.
It would be nice if as I leave sheet ONE the program could "rememebr" where
I came from. That way I would not need a hyperlink back on EVERY entry in
sheet two in order to return to the proper place on sheet ONE.
If somehow when I clicked on an entry in sheet one, it recorded the location
I was at so that when I click sheet two to return it could read that address.
Thansk
 
Try adding the Web toolbar and clicking the back (left) arrow.
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html




"pcor"
wrote in message
Yes that is true...but.
It would be nice if as I leave sheet ONE the program could "rememebr" where
I came from. That way I would not need a hyperlink back on EVERY entry in
sheet two in order to return to the proper place on sheet ONE.
If somehow when I clicked on an entry in sheet one, it recorded the location
I was at so that when I click sheet two to return it could read that address.
Thansk
 
Or you can use shortcut Alt+arrowleft
Or if you have a 5 button mouse, use the Back button
 
Most sincere thanks to both Jim & David.
Can you tell me where I can get all that kind of info
Thansk Again
 
Hi "pcor", (the use of actual names works best in this newsgroup)
To learn Excel or any other application the first place to start is to learn
the menu options and look in HELP.

Keyboard Shortcuts are in help, Back and Forward are pretty much universal
and are fairly consistent cross application. The Excel shortcuts for links follow
what is available in Internet Explorer.

I have a page on Keyboard shortcuts in Excel
http://www.mvps.org/dmcritchie/excel/shortx2k.htm
originally it was to show how you could make up your own list from HELP,
but it took a bit more work so I made it into a web page so others don't
have to gather together all of the help pages on keyword shortcuts to find
something. On one web page you can simply use FIND in your browser..

Pages on use of the mouse [in Windows]
Fill-Handle, Replication and use of the Mouse
http://www.mvps.org/dmcritchie/excel/fillhand.htm
Notes on Mouse Wheel and Button Settings
http://www.mvps.org/dmcritchie/excel/mouse.txt

To learn more about Excel in an organized fashion, you might
start with Tutorials available on the web, Some links at
http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials

More information on hyperlinks can be found in
Build Table of Contents, similar listings, working with Hyperlinks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
 
Very useful information
Many thanks
Ian M
David McRitchie said:
Hi "pcor", (the use of actual names works best in this newsgroup)
To learn Excel or any other application the first place to start is to learn
the menu options and look in HELP.

Keyboard Shortcuts are in help, Back and Forward are pretty much universal
and are fairly consistent cross application. The Excel shortcuts for links follow
what is available in Internet Explorer.

I have a page on Keyboard shortcuts in Excel
http://www.mvps.org/dmcritchie/excel/shortx2k.htm
originally it was to show how you could make up your own list from HELP,
but it took a bit more work so I made it into a web page so others don't
have to gather together all of the help pages on keyword shortcuts to find
something. On one web page you can simply use FIND in your browser..

Pages on use of the mouse [in Windows]
Fill-Handle, Replication and use of the Mouse
http://www.mvps.org/dmcritchie/excel/fillhand.htm
Notes on Mouse Wheel and Button Settings
http://www.mvps.org/dmcritchie/excel/mouse.txt

To learn more about Excel in an organized fashion, you might
start with Tutorials available on the web, Some links at
http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials

More information on hyperlinks can be found in
Build Table of Contents, similar listings, working with Hyperlinks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm


pcor said:
Most sincere thanks to both Jim & David.
Can you tell me where I can get all that kind of info
Thansk Again
Click to expand...
Click to expand...
 
Back
Top