table of content page in excel

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

Guest

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
 
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
 
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
 
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
 
Back
Top