Sometimes, when using filters in Excel, it only includes lines down to the first empty cell/row. What do I do when there are numerous emtpty cells in one collumn?
B
Sometimes, when using filters in Excel, it only includes lines down to the first empty cell/row. What do I do when there are numerous emtpty cells in one collumn?
B
the filter should only stop when it comes to a completely empty row if you are filtering a whole table. if not, select all the rows first, then apply the autofilter.
Josie
if at first you don't succeed try doing it the way your wife told you to
remove the filter, then high-light the entire range that you will be applying the filter to, before you apply the filter
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks