ISBLANK Function

• 1). Open the Excel worksheet with the data you want to check.
  
  
• 2). Enter an appropriate header in the first empty column.
  
  
• 3). Input "=isblank(B2)" on the row corresponding to the first data you want to check and press "Enter." This formula says, "Cell B2 is empty." If that statement is true, it returns a value of "TRUE." Otherwise, it returns a value of "FALSE."
  
  
• 4). Copy the cell containing the formula. Select all the cells corresponding to the data you want to check. Paste the formula.
  
  
• 5). Select the "Data" tab on the menu and select the "Filter" button.
  
  
• 6). Click the filter arrow at the top of the column containing the formula. Select "TRUE" to see the rows or columns with empty cells.
  
  

LEN Function

• 1). Open the Excel worksheet you want to check.
  
  
• 2). Enter an appropriate header in the first empty column.
  
  
• 3). Input---on the row corresponding to the first data you want to check---the following:
  
  =if(LEN(B2)<1, "EMPTY", "NOT EMPTY")
  
  Press "Enter."
  
  This formula says:
  
  If the value of LEN is less than 1 (O), then input "EMPTY," if the value of LEN is not less than 1(O) then input "NOT EMPTY."
  
  
• 4). Copy the cell containing the formula. Select all the cells corresponding to the data you want to check. Paste the formula.
  
  
• 5). Select the "Data" tab on the menu and select the "Filter" button.
  
  
• 6). Click the filter arrow at the top of the column containing the formula. Select "TRUE" to see the rows or columns with empty cells.
  
  

IF Function

• 1). Open the Excel worksheet you want to check.
  
  
• 2). Enter an appropriate header in the first empty column.
  
  
• 3). Input---on the row corresponding to the first data you want to check---the following:
  
  =if(B2="", "EMPTY", "NOT EMPTY")
  
  Press "Enter."
  
  
• 4). Copy the cell containing the formula. Select all the cells corresponding to the data you want to check. Paste the formula.
  
  
• 5). Select the "Data" tab on the menu and select the "Filter" button.
  
  
• 6). Click the filter arrow at the top of the column containing the formula. Select "TRUE" to see the rows or columns with empty cells.