There are two ways to filter for blank or non-blank cells in Excel:

1. Using the Filter Menu:

1. Select your data range: Click on any cell within the data set you want to filter.
2. Activate the Filter: Go to the "Data" tab on the Excel ribbon. Click the "Filter" button in the "Data Tools" group. This will add filter arrows to the header row of your data.
3. Filter by Blanks or Non-Blanks: Click on the filter arrow for the column you want to filter. In the dropdown menu, you'll see an option for "(Blanks)" to show only rows with blank cells in that column. Alternatively, you can choose "(Select All)" and uncheck everything except your data to display only non-blank cells.

2. Using Custom Filter Criteria (for more control):

1. Follow steps 1 and 2 from method 1.
2. Click on the filter arrow and choose "Number Filters..."
3. Select "Custom Filter" from the submenu.
4. Choose the criteria: In the "Custom Filter" dialog box, you have two options:
* For blank cells: Choose "Blanks" from the dropdown menu next to "Field".
* For non-blank cells: Choose "Does not equal" and leave the "Value" box empty.
5. Click OK: Click "OK" to apply the filter and display the desired results.

Both methods effectively filter your data based on the presence or absence of content in the chosen column.