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...
spbocgirl , i hope you are selecting the complete table and then applying the auto filter. If you select just the top row, then Excel may not apply auto filter on complete table.
(Easy method of selecting the complete table is : select top-left cell and press ctrl+shift+end)
/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.
