How to filter blanks or non-blanks with one click
A free Office suite fully compatible with Microsoft Office
Multiple blank cells in a table are inconvenient for us to look up data. How can we hide them with just one click?
1. Place your cursor at any cell. Click the Filter button at Home or you can use shortcut Ctrl+Shift+L. Then a green corner marker will show in the header line, indicating you are in the filter mode.
2. Select the column you'd like to filter. Click the green icon and the data list to filter will pop up. Here, you can choose what to filter.
3. Hover the cursor at Blanks and two options Filter Blanks and Filter Non-blanks will appear.
Note that you can only find them when the cells you selected contain blank cells.
In this case, after selecting Filter non-blanks, all the blank cells in this table will be hidden instantly.
On the contrary, if you click Filter blanks, the null value can be filtered with one click.
This function can improve data processing efficiency and save you much time in the filtering process. Did you get it? Go and try now!
Was this helpful?
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to compare two excel sheets and highlight differences
- 4. How to copy file names in Excel from a folder?
- 5. How to color cell based on value in Excel?
- 6. How to add month name from date in Excel formula