Is there a way to do a TOC in excel like in Word as a field?

Thank you,

DAn

Give this a look...

http://www.dicks-blog.com/archives/2...e-of-contents/

--
HTH...

Jim Thomlinson


"Daniel R. Young" wrote:

Is there a way to do a TOC in excel like in Word as a field?

Thank you,

DAn

Daniel,

My Excel add-in "Excel Extras" adds a "Table of Contents" item
to the Insert Menu. It adds a new sheet to the workbook with
a list of all sheets and the number of printable pages.
Also, each sheet name is hyperlinked to the actual sheet.

The add-in has additional features including...
Sheet sorting
Print area determination
Adding to or clearing the Header and Footer
Font options
Unhide all sheets with one click

It is available - free - upon direct request.
Comes with a Word.doc install/use file.
(remove xxx from my email address)

Regards,
Jim Cone
San Francisco, USA
XX


"Daniel R. Young" wrote in message
...
Is there a way to do a TOC in excel like in Word as a field?

Thank you,

DAn

See http://www.mvps.org/dmcritchie*/exce...c.htm#buildtoc

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Daniel R. Young" wrote in message
...
Is there a way to do a TOC in excel like in Word as a field?

Thank you,

DAn

You have an improper "-", try:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm
"Bob Phillips" wrote in message
...
See http://www.mvps.org/dmcritchie*/exce...c.htm#buildtoc

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Daniel R. Young" wrote in
message
...
Is there a way to do a TOC in excel like in Word as a field?

Thank you,

DAn