How to Find and Count Non-Blank Cells – 4 Methods - ExcelDemy To see ‘Done’ in non-blank cells and ‘Pending’ in blank cells Step 1: Select D5 Press Enter Step 2: Drag down the Fill Handle to see the result in the rest of the cells This is the output Read More: How to Check If Cell Is Empty in Excel To see TRUE in empty cells and FALSE in non-empty cells: Steps: Select D5 Press Enter