| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering a column and not all cells are available
When I try to filter a column which contains numbers from 0 to 9430 not all
those numbers are available to filter by. There are no blank cells in the filtered column, all cells are formated as numbers. The filter will only give me 0-6430 as filtered cells. How do I get all the cells to filter? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Filtering a column and not all cells are available
Hi
See this page http://www.contextures.com/xlautofilter02.html#Limits -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jkd7058" wrote in message ... When I try to filter a column which contains numbers from 0 to 9430 not all those numbers are available to filter by. There are no blank cells in the filtered column, all cells are formated as numbers. The filter will only give me 0-6430 as filtered cells. How do I get all the cells to filter? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering for Like Items in a Column | Excel Discussion (Misc queries) | |||
| Need help filtering a date column | Excel Discussion (Misc queries) | |||
| Filtering numbers in a column? | Excel Worksheet Functions | |||
| trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
| column filtering to match identical numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
