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

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Peter Barker" wrote in message
...
I have a long spread sheet which has a number of specific sections to it.
Does anyone know whether it's possible to set a 'table of contents' at the
top of the page so that I can click on one of the titles and it will jump
down to that section. At the moment I have to keep scrolling down the
page
which takes forever. Many thanks for any help anyone can provide.