ExcelBanter - Excel Auto Filter will not show all items in the drop down

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel Auto Filter will not show all items in the drop down - why? (https://www.excelbanter.com/excel-discussion-misc-queries/150159-excel-auto-filter-will-not-show-all-items-drop-down-why.html)

Gerin

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?

Mike H

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?

David Biddulph[_2_]

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?

All times are GMT +1. The time now is 07:23 PM.