If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|