How can I scroll within an alphabetical list in Excel?

  • Thread starter Thread starter mkfrl
  • Start date Start date
M

mkfrl

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!
 
Hmm, simplest idea I can think of...Put something at the top of each
"section" that you know will always sort to the top of that section...I'll
let you play with that.

Once you have those cells in place...highlight the one for the "A" section
and type the letter "A" into the Name Box (just to the left of the formula
bar).

Repeat for the flag cell for each section.

Now, you can press CTRL-G to open the GOTO window, type the letter "A" and
ENTER and it will jump you to that flag cell.
 
Back
Top