Hyperlinking within a workbook

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 after
following the online wizard, my hyperlink doesn't do anything (doesn't
navigate to the sheet, doesn't give me an error). Unfortunately, the
online help in excel only discusses how to link to a sheet in another
workbook.

Keith


---
Message posted from http://www.ExcelForum.com/

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.


In article ,
keith0628 wrote:

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 after
following the online wizard, my hyperlink doesn't do anything (doesn't
navigate to the sheet, doesn't give me an error). Unfortunately, the
online help in excel only discusses how to link to a sheet in another
workbook.

Keith


---
Message posted from http://www.ExcelForum.com/

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
-----Original Message-----
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 after
following the online wizard, my hyperlink doesn't do
anything (doesn't
navigate to the sheet, doesn't give me an error).
Unfortunately, the
online help in excel only discusses how to link to a
sheet in another
workbook.

Keith


---
Message posted from http://www.ExcelForum.com/

.

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.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"JE McGimpsey" wrote in message ...
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.


In article ,
keith0628 wrote:

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 after
following the online wizard, my hyperlink doesn't do anything (doesn't
navigate to the sheet, doesn't give me an error). Unfortunately, the
online help in excel only discusses how to link to a sheet in another
workbook.

Keith


---
Message posted from http://www.ExcelForum.com/

Octothorpe??

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

Glad to make your acquaitance.

Gord

On Mon, 14 Jun 2004 14:55:54 -0600, JE McGimpsey wrote:

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.


In article ,
keith0628 wrote:

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 after
following the online wizard, my hyperlink doesn't do anything (doesn't
navigate to the sheet, doesn't give me an error). Unfortunately, the
online help in excel only discusses how to link to a sheet in another
workbook.

Keith


---
Message posted from http://www.ExcelForum.com/