Excel autofilter stops filtering
Solved/Closed
Related:
- How to remove auto filters in excel
- Automatic filters in excel - Best answers
- Excel vba autofilter not working - Best answers
- How to stop auto refresh in facebook app - Guide
- How to remove auto translate in facebook - Guide
- How to take screenshot in excel - Guide
- Grand theft auto 1 download - Download - Action and adventure
- How to remove recent files in windows 11 - Guide
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"
