Forum Discussion
spbocgirl
May 28, 2020Copper Contributor
Maximum number of rows an auto filter can handle
I've been using Excel for many years and I've come across this issue but never asked anyone about it. I use the filter often. I have noticed that if my worksheet has many rows, the filter doesn't f...
spbocgirl
May 28, 2020Copper Contributor
/amit_bhola Thank you. I didn't know this would be necessary, since normally all you have to do go up to the home cell (CNTL-Home) and have it automatically filter the spreadsheet based on your column criteria. Why doesn't go all the way to the bottom? Why this extra step? (Questions for MS, I guess.)
I appreciate your answer, though. Thanks.
mtarler
May 28, 2020Silver Contributor
I don't have a complete or definitive answer but it can 'stop' recognition if there are blank cells or if rows get cleared vs deleted. I'm sure there are other reasons too and probably a more detailed list of criteria. Best to select the entire table and format as table so the entire range is recognized as a table and then table filters should work.