Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Excel Functions (Array) to put a list in alphabetical order | Excel Discussion (Misc queries) | |||
Alphabetical List Box | Excel Discussion (Misc queries) | |||
I'm useing Excel I have a list of names that I need alphabetical | Excel Worksheet Functions | |||
How may I make a list display in alphabetical order in Excel? | Excel Discussion (Misc queries) | |||
How do I get my Excel document list in alphabetical order | Setting up and Configuration of Excel |