How do I skip to a letter in an alphabetically sorted list?

[Guest]

I have createad a database and alphabetically sorted the items - is there a
shortcut or a quick way to jump to a particular letter rather than scrolling
down the whole thing to find 'r' etc?

 

[Carim]

Hi,

Could Ctrl F be of any help ...???

Cheers
Carim

 

[Roger Govier]

Hi

You could "cheat"
Insert a column before your list of items. Lets assume you inserted a
new column A
In cells A1 enter
=LEFT(B1)
Double click on the fill handle (the small black cross that you see when
you hover over the bottom right of the cell) and this will copy the
formula down the column for you.
Place your cursor in cell A1 and Data>Filter>Autofilter
Use the dropdown to select the letter you want, and you will see a
filtered list of only the items beginning with that letter.