How to not ignore blank rows when filtering in Excel?
If there are some blank rows in the range which you want to filter, the data cannot be filtered correctly if you directly apply the Filter function into the headers of the range as below screenshot shown. This article will tell you how to include blank rows when filtering in Excel.
To correctly filter the range with blank rows, you just need to do as this:
Drag mouse to select the whole range you want to filter, and then click Data > Filter to enable the Filter function. Now the blank rows and all data have been included.
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...