Excel autofilter stops filtering
Solved/Closed
Related:
- Excel filter not working after certain row
- Auto filter in excel - Best answers
- How to remove auto filters in excel - Best answers
- Excel date format dd/mm/yyyy not working - Guide
- Excel create unique id for each row ✓ - Excel Forum
- Position formula in excel ✓ - Office Software Forum
- Arrow keys not working in excel - Guide
- Kernel for excel - Download - Backup and recovery
23 responses
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
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 22, 2010 at 01:40 PM
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"