Hyperlinking within a workbook

K

keith0628

I have a workbook with more sheets than I can easily navigate through.
I would like to create hyperlinks that jump to other pages, but afte
following the online wizard, my hyperlink doesn't do anything (doesn'
navigate to the sheet, doesn't give me an error). Unfortunately, th
online help in excel only discusses how to link to a sheet in anothe
workbook.

Keit
 
J

JE McGimpsey

One way:

Right-click your source cell and choose Hyperlink....

In the "Link To" box, enter an octothorpe (#) followed by the cell
reference. If the reference is to another sheet, use the sheet name and
address, separated by an exclamation mark, e.g.:

#A1
#Sheet2!J10

Enter whatever text you want in the Display box.
 
J

jeff

Hi, Keith,

I can't imagine what is wrong. If you go to
Insert->Hyperlink; on the left side ("Link to:")
be sure to click on "Place in this Document"; then
be sure to click on the target sheet, adjust the
text, and click OK.

Should work. Are you doing all this??

jeff
 
D

David McRitchie

Take a look at
Build Table of Contents, similar listings, working with Hyperlinks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

If you want to do to specific cells on a lot of pages all with
exactly the same format see
Build TOC Another Approach
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm

octothorpe (#), even if I see that word 100 more times I'll
never remember it, except that I've seen it so many times.
Sounds neater than insert space (#) which is what I found
in my ACD. So not being able to locate another dictionary.

I found this on the web. WHAT THE ####?
http://www.sigtel.com/tel_tech_octothorpe.html
Most programmers would call it as the (commercial) pound sign
or refer to it as one of the National characters (as in NCR),
or as the number sign. Never realized that the pound sterling
sign was exactly x80 up from the number sign.

But I think octothorpe really only only caught on referring to
telephone handsets.
 
G

Gord Dibben

Octothorpe??

There are three of us in the world that know what an octothorpe is.

Glad to make your acquaitance.

Gord
 
Top