table of content page in excel

F

FMMM

i was able to set up the hyperlink but i would also like to include the page
number in the table of content page. how do i get it to look like this.

Report..............1
Report II...........2
 
G

Gord Dibben

Are you creating the hyperlink using Insert>Hyperlink>Place in this Document?

If so, you can supply the text in the "Test to Display" dialog box when you edit
the hyperlink.


Gord Dibben MS Excel MVP
 
F

FMMM

I'm creating my hyperlink through insert - hyperlink-place in this document
but I dont see the test to display dialog. Can you please give me step by
step on how i can use this to add the page number.

Thanks so much
 
G

Gord Dibben

Was a typo......should have read ''Text to display" not "Test to display"

Insert>Hyperlink and a dialog will open.

On left side is a menu of places to link to.

At top is a dialog box named "Text to Display"

Type Report.........Page 1 into that dialog box.


Gord
 
Top