ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

1 Q & A posts tagged with randomly

Mon
Apr 6
2009

In Microsoft Excel, the auto filter does not show all my items that are listed.?

There are a lot of drop downs, but it randomly does not have all come up in the list. If I go to them in the spreadsheet, they are in there correctly but do not appear in the filter drop down. Does anyone know why this is? thanks


Answer

Autofilter requires no empty spaces between rows
That could be the reason
Or

Make sure that you disable / enable the Auto filter

VBAXLMan

Monday 4/6/2009 7:58:05 AM

Tags

History