Hi,

If the list is already sorted in ascending order, your effort can
significantly reduce by just applying an auto filter on the range. Then in
the filter drop down you can simply scroll to J or any other alphabet.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Raz" wrote in message
...
i have a very long spreadsheet with Names in the first column, (sorted
alphabeticaly) and corresponding other data to the right columns.

when I look for a name I have to scroll down forever to reach to the
appropriate name.
is there a quicker way to scroll.
for example If I am looking for John, I press J and it takes me to where
names starts with a J.