Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
table of content page in excel
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
table of content page in excel
Are you creating the hyperlink using InsertHyperlinkPlace 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 On Wed, 22 Aug 2007 16:10:02 -0700, FMMM wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
table of content page in excel
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 "Gord Dibben" wrote: Are you creating the hyperlink using InsertHyperlinkPlace 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 On Wed, 22 Aug 2007 16:10:02 -0700, FMMM wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
table of content page in excel
Was a typo......should have read ''Text to display" not "Test to display"
InsertHyperlink 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 On Thu, 23 Aug 2007 10:46:02 -0700, FMMM wrote: 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 "Gord Dibben" wrote: Are you creating the hyperlink using InsertHyperlinkPlace 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 On Wed, 22 Aug 2007 16:10:02 -0700, FMMM wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating table of content in excel workbook | Excel Worksheet Functions | |||
hyperlink from pivot table content | Excel Discussion (Misc queries) | |||
How to host a site with pivot table content? | Excel Discussion (Misc queries) | |||
Creating a Table of Content in Excel | Excel Discussion (Misc queries) | |||
content does not stay in page break | Excel Worksheet Functions |