View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mkfrl mkfrl is offline
external usenet poster
 
Posts: 1
Default How can I scroll within an alphabetical list in Excel?

I have a spreadsheet in Excel which contains a very long list of clients
(30,000 or so). I have them sorted alphabetically, but I would like to be
able to key a letter and have the spreadsheet jump to the section where it
begins. For example, is there a way to set up the spreadsheet so that I can
hit, say 'F' and the sheet scrolls to the section where the inputs beginning
with the letter 'F' begin? Thanks in advance!