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!

How can I scroll within an alphabetical list in Excel?
 

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.

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"mkfrl" wrote:

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!