It's achievable that you have established conflicting filters. Try clearing many of your filters. Should you be employing a personalized filter, Verify your "and/or" logic. Many thanks! We're glad this was helpful. How can I established Excel 2007 in order that on opening, AutoFilter should have the "choose all" box https://auto-filter43085.blogolize.com/the-definitive-guide-to-auto-filter-73127446