How can I scroll within an alphabetical list in Excel?

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!
 
J

JBeaucaire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top