How to Remove Blank Non

1. Open the Microsoft Excel spreadsheet that you want to filter.
2. Highlight the range of cells that you want to include in the filter. You can highlight multiple cells by clicking while holding down the 'Shift' key.
3. Open the 'Data' menu at the top of the window, expand the 'Filter' submenu and select 'AutoFilter.' This will add an arrow button to the top of each highlighted column.
4. Click on the arrow button on one of the columns and select '(Blanks)' from the drop-down menu to show all blank cells and remove all non-blank cells.
5. Click on the arrow button on one of the columns and select '(NonBlanks)' from the drop-down menu to reverse the action. Now all non-blank cells will be shown and all blank cells will be removed.
6. Go back to the 'Data' menu and uncheck the 'AutoFilter' option to remove the filters and see all of the cells again.