• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • Product ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
Techwalla
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Check If a Cell Is Empty in Excel Program?

How to Check If a Cell Is Empty in Excel Program?

March 31, 2015
By: Kate Bluest
  • Share
  • Share on Facebook

In large complex spreadsheets, locating empty cells requires more than a glance. There are many methods available to make the task of identifying empty cells easier. They include the three function methods called ISBLANK, LEN and IF.

Video of the Day

...
Just a few clicks on the keyboard using the right Excel function can save you hours of time.

The ISBLANK function returns the logical value of TRUE if the cell is empty. The LEN function returns a value containing the number of characters in a string or the number of bytes required to store a variable in a cell. If a cell is blank, that value will be zero according to Microsoft. You can use the IF function with empty quotes ("") to test for empty cells.

To clarify the formula examples, "B2" represents the cell containing the data you want to test. "E2" represents the cell in which you enter the formula. Use the values of your data in place of these cell addresses. To keep your formulas simple, If your headers are on a row, the row numbers should match, if your headers are on a column, the column letters should match.

ISBLANK Function

Step

Open the Excel worksheet with the data you want to check.

Step

Enter an appropriate header in the first empty column.

Step

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."

Step

Copy the cell containing the formula. Select all the cells corresponding to the data you want to check. Paste the formula.

Step

Select the "Data" tab on the menu and select the "Filter" button.

Step

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

Step

Open the Excel worksheet you want to check.

Step

Enter an appropriate header in the first empty column.

Step

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."

Step

Copy the cell containing the formula. Select all the cells corresponding to the data you want to check. Paste the formula.

Step

Select the "Data" tab on the menu and select the "Filter" button.

Step

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

Step

Open the Excel worksheet you want to check.

Step

Enter an appropriate header in the first empty column.

Step

Input—on the row corresponding to the first data you want to check—the following:

\=if(B2="", "EMPTY", "NOT EMPTY")

Press "Enter."

Step

Copy the cell containing the formula. Select all the cells corresponding to the data you want to check. Paste the formula.

Step

Select the "Data" tab on the menu and select the "Filter" button.

Step

Click the filter arrow at the top of the column containing the formula. Select "TRUE" to see the rows or columns with empty cells.

Show Comments

Related Articles

How Do You Resize a Cell & Not a Column in Excel

How Do You Resize a Cell & Not a Column in Excel

Around The Home
Productivity
By: BrianW
How to Make a Skew Graph in Excel

How to Make a Skew Graph in Excel

Around The Home
Productivity
By: John Papiewski
How to Make an Employee Weekly Performance Tracker Using Excel

How to Make an Employee Weekly Performance Tracker Using Excel

Around The Home
Productivity
By: Peter Franczyk
How to Insert a Row or Column in an Excel Spreadsheet

How to Insert a Row or Column in an Excel Spreadsheet

Around The Home
Productivity
By: Carol Finch
How to Add a Yes or No Box to an Excel Spreadsheet

How to Add a Yes or No Box to an Excel Spreadsheet

Around The Home
Productivity
By: Aaron Parson
How to Calculate Gross Profit Margin Using Excel

How to Calculate Gross Profit Margin Using Excel

Around The Home
Productivity
By: David Weedmark
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2018 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.