Forum Discussion
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...
/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.
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.