May 27 2020 11:46 PM
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 filter the whole worksheet, i.e. doesn't filter all the way down to the last row.
What is the maximum number of rows the filter can handle?
Other than using the Advanced Filter, which I've never learned, is there anything I can do to get the filter to filter the whole worksheet?
May 28 2020 12:03 PM
@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)
May 28 2020 04:22 PM
/@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.
May 28 2020 04:39 PM
May 28 2020 08:16 PM
@mtarler Yes, I discovered a while back that the filter can't hop over blank rows. And it's never easy to answer the "why" questions... unless you are the one who designed the program. Thanks for replying.