Excel autofilter stops filtering
Solved/Closed
Related:
- Excel filter not working
- Filter not working in excel - Best answers
- Excel filter not working after certain row - Best answers
- Excel filter based on cell value without vba ✓ - Forum - Excel
- How to change date format in excel filter - Guide
- Excel filter formula multiple sheets - Guide
- Excel Filter/Macro ✓ - Forum - Excel
- Excel filter by day of week ✓ - Forum - Excel
23 replies
Hi all,
I had a similar problem in the past weeks - the auto filter was freezing after a couple of use and I had no other choice than to remove the autofilter and unhide the hidden rows before putting it back for a couple more uses.
A colleague then reminded me of a common practice: instead of adding a filter to the title row, insert a blank row between the row bearing the column titles and your first row of proper data, and add the filter to that blank row. Well, it works for me. I think the filter gets stuck when the column titles get too long for some reason.
I had a similar problem in the past weeks - the auto filter was freezing after a couple of use and I had no other choice than to remove the autofilter and unhide the hidden rows before putting it back for a couple more uses.
A colleague then reminded me of a common practice: instead of adding a filter to the title row, insert a blank row between the row bearing the column titles and your first row of proper data, and add the filter to that blank row. Well, it works for me. I think the filter gets stuck when the column titles get too long for some reason.
im using the formula to add =sum(b2:b184) and then enter but it doesnt work
rizvisa1
Jul 22, 2010 at 01:40 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jul 22, 2010 at 01:40 PM
make sure the cell is formatted to be "general" and if it is so, could you explain more beside "does not work"