1 / 4

How to Filter on Blanks quickly

How to Filter on Blanks quickly? - Check if you have a Search textbox in the filter dropdown. If yes, just type an opening bracket there (.<br>https://efficiency365.com/2016/08/22/how-to-filter-on-blanks-quickly/

efficiency365
Download Presentation

How to Filter on Blanks quickly

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. How to Filter on Blanks quickly https://efficiency365.com/2016/08/22/how-to-filter-on-blanks-quickly/

  2. How to Filter on Blanks quickly A simple but very useful method. All of us use AutoFilter in Excel. The dropdown shows unique values in the column. Sometimes we just want to see the rows with blank cells. Unfortunately, the (blank) item appears at the end of the list. If the data contains many unique values, you have to waste time and scroll manually to the bottom of the long list. Often, after reaching the list we realize that we should actually have unselected all the items first. Then you go up again! Pathetic. Here is a smart way to Filter on Blanks instantly. Here is a simple solution. Check if you have a Search textbox in the filter dropdown. If yes, just type an opening bracket there ( Now, the blank item is shown directly and it is the only one selected. Quick and Easy.

  3. How to Filter on Blanks quickly

  4. How to Filter on Blanks quickly If you do not see the Search textbox, you are using an older version of Excel. This feature was added in 2010. Same functionality works in Pivot Table field dropdowns as well.

More Related