Hi
Use HYPERLINK:
On Menu bar select 'Insert' 'Hyperlink'
Then click on 'Place in this Document'
Type in the cell reference where the letter appears that you want to link to
e.g A8
Type in Text to display e.g. A - OK
Do that for every letter.
Probably the letter will turn blue with an underline which will indicate a
hyperlink is present.
You can change that if you wish by formatting as usual.
Trust this helps


"Barb Reinhardt" wrote:

Have you thought about using AutoFilter and searching for "Begins with" A?
Otherwise, I think you're going to need to have a lot of code information is
added and deleted from this worksheet.
--
HTH,
Barb Reinhardt



"cdunn238" wrote:

I have to edit an existing spreadsheet with an index and want to have an
alphabet listing at the top so
that when you click on the letter you're linked to the first cell in that
section that starts with that letter.
Example:

Provisioning--(Name of Document)

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

A items run from B8 - B 20
B items run from B22 - B 25
C items run from B27 - B33

and so on.

Please tell me how to link each alphabet to the subject beginning with that
letter?

PS can I save the spreadsheet as a web page doc also?

Thanks,