You can name the top cell in each range then pick that name from the namebox to
jump.

InsertNameDefine


Gord Dibben MS Excel MVP

On Sat, 10 Feb 2007 03:56:00 -0800, Peter Barker
wrote:

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.