How to create hyperlink for an area

[et]

Dear all,

I have an excel file includes nearly hundred of wheetsheet, in order to let
the reader go to the page easily & quickly, I want to set hyperlink on a
page called "content", but I don't know how to set it, hope you can help,
thanks.

Eling

 

[Norman Jones]

Hi Eling,

Visit David McRitchies site and look at his notes on building a table of
contents:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm

 

[macgru]

Dear all,

I have an excel file includes nearly hundred of wheetsheet, in order to let
the reader go to the page easily & quickly, I want to set hyperlink on a
page called "content", but I don't know how to set it, hope you can help,
thanks.

Eling

u can try this add-in
http://www.asap-utilities.com/

it allows u 2 create an index page
macgru

 

[et]

It works, thanks a lot.