Tip Printed from ExcelTip.com

---

Filtering is limited to 999 items in Microsoft Excel


The number of items available for filtering is limited. Excel cannot filter columns in which the number of items exceeds 999 (not the number of rows).
To filter when there are more than 999 items, use Advanced Filter.