One quick way to get where you want is to:
1)Select the column with the names.
2)Press [Ctrl]+F. (or EditFind)
3)Enter the beginning of what you're looking for followed by and asterisk:
Example: Names beginning with G would be entered G*
4)Click the box to "Match entire contents of cell"
5)Click OK
Excel will bring you to the 1st name beginning with G.
I hope that helps.
Regards,
Ron
|