| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why don't all entries in column appear on drop down filter?
Using Office/Outlook 2007
I have put a filter on a very long spreadsheet but have found out that not all of the info in a particular column appears. There are approx 600 unique numbers & I have checked that they are all formatted the same. I want to make sure that the filter will choose any of the info in the required column. Thanks for any assistance. Regards |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why don't all entries in column appear on drop down filter?
Make sure there are no blanks in the column that might limit the scope of the
filter. -- Gary''s Student - gsnu200859 "Babs162" wrote: Using Office/Outlook 2007 I have put a filter on a very long spreadsheet but have found out that not all of the info in a particular column appears. There are approx 600 unique numbers & I have checked that they are all formatted the same. I want to make sure that the filter will choose any of the info in the required column. Thanks for any assistance. Regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I lock a drop down cell so only drop down entries can be e. | Excel Discussion (Misc queries) | |||
| Filter to Duplicate Entries Only | Excel Discussion (Misc queries) | |||
| Create a drop down box in a column with specific entries ? | Excel Worksheet Functions | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Unique Records Filter-Updating new entries | Excel Discussion (Misc queries) | |||
Linear Mode
