| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Auto Filter will not show all items in the drop down - why?
I have a huge spreadsheet.
I started the Auto Filter. In the drop down for one of the rows it will not show me the content even though the filter is set for "ALL" on each column - any idea why? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Auto Filter will not show all items in the drop down - why?
Hi,
It' limited to 1000 prior to Excel 2007. Mike "Gerin" wrote: I have a huge spreadsheet. I started the Auto Filter. In the drop down for one of the rows it will not show me the content even though the filter is set for "ALL" on each column - any idea why? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Auto Filter will not show all items in the drop down - why?
But see http://www.contextures.com/xlautofilter02.html for a workround.
-- David Biddulph "Mike H" wrote in message ... Hi, It' limited to 1000 prior to Excel 2007. Mike "Gerin" wrote: I have a huge spreadsheet. I started the Auto Filter. In the drop down for one of the rows it will not show me the content even though the filter is set for "ALL" on each column - any idea why? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count items with auto-filter | Excel Discussion (Misc queries) | |||
| Print Pivottable - show all selected items in page filter | Excel Discussion (Misc queries) | |||
| Counting items in auto filter - how? | Excel Discussion (Misc queries) | |||
| Excel auto filter does not show all choices for the field? | Excel Discussion (Misc queries) | |||
| Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW . | Excel Worksheet Functions | |||
Linear Mode
