You could put the alphabet (one character in each cell) at the top of your list.

The assign a hyperlink to that cell that goes to location that you want.

Select the cell
Insert|hyperlink
Place in this document
type in the cell address.

Alternatively, you could use the =hyperlink() formula:

This will go to A19 of the activesheet and display L in the cell.
=HYPERLINK("#a19","L")



BobB wrote:

I have an Excel file with 9000 records and 15 fields sorted alphabetically. I
want to set up the letters of the alphabet at the top so that if I click a
letter it will scroll to the first record wih that letter. I have seen this
often on WEB pages. Can it be done in Excel? What is the name of this device?
If it is a program, where can I find it? I have Office 2003 Excel.

Thanks for your help.

Bob Barckley


--

Dave Peterson