| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
The filter didn't show all (2,254) names when I set it up
I set up auto filter to sort my names in my company spreadsheet. There are
2254 names and all of there info in the rows. When I click the arrow in the Name column I can only see the names up to the M's (1880 of them) and not the rest of the names down to the Z's. So I want to filter on Motz and his name is not listed in the filter choices. No names beyond Mapps are listed. How can I get my filter choices to show all 2254 names from A-Z to show on the filter choice drop down window? Or is there a cap on how many things this little window will display? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Local Names to Global Names | Excel Worksheet Functions | |||
| filter 400 names from list 1 from list 2 with 4000 names | Excel Worksheet Functions | |||
| Show Existing Names | Excel Discussion (Misc queries) | |||
| Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Threaded Mode
