To test whether a cell is truly empty in Excel, use =ISBLANK(A1), replacing A1 with the cell you want to check. It returns TRUE only when the cell contains nothing; if you also want to treat a formula returning an empty string as blank, use =A1="" instead.
The fastest way to test a blank cell
For Microsoft Excel for Microsoft 365 on Windows, enter the test in a different cell, such as B1, and press Enter. If A1 is genuinely empty, the ISBLANK test displays TRUE; if A1 contains a value, text, a space, or a formula, it displays FALSE. The test does not change the cell being checked.
To display a useful label instead of TRUE or FALSE, wrap the test in IF. With the cell to check in A1, enter =IF(ISBLANK(A1),"Blank","Not blank"). This returns “Blank” for a genuinely empty cell and “Not blank” for anything else. You can copy the formula down a column to check a list, and Excel will adjust A1 to A2, A3, and so on.
ISBLANK takes a cell reference as its argument, not a value to evaluate by its appearance. A cell that looks empty on screen may still contain a formula or invisible characters, so it helps to decide what “blank” should mean for your task before choosing a test.
What Excel means by an empty cell
A truly empty cell has no value, text, formula, or other cell content. Selecting a cell and clearing its contents makes it genuinely empty; applying a white font or a number format that hides a value only changes how the cell looks. ISBLANK checks whether the cell itself is empty, not whether its displayed appearance is blank.
This distinction matters in imported files, templates, and worksheets that use formulas to hide results. For example, a formula may return an empty string so a report does not show a zero or a label before data is entered. The cell then appears blank, but the formula is still present. ISBLANK returns FALSE because the cell contains that formula.
Other content can also be easy to miss. A cell may contain one or more spaces, a nonbreaking space copied from a web page, or a formula that returns a space. These are not the same as an empty cell. A test based on ISBLANK will correctly report FALSE for them, even if you cannot see the content at the current zoom or column width.
Choose the test that matches your definition
Use ISBLANK when the distinction is whether a cell has any content at all. Use an equality test against an empty string when a formula-produced empty result should count as blank too. For a quick comparison, with the cell being checked in A1:
=ISBLANK(A1)is TRUE only when A1 is genuinely empty.=A1=""is TRUE for a genuinely empty cell and for a formula that returns an empty string.=LEN(A1)=0checks whether the evaluated text length is zero; it also treats an empty cell as having zero length.
The second and third tests are not general-purpose ways to find every cell that looks empty. A cell containing a space has a length greater than zero, so it will not pass either test. If A1 contains an error value, comparisons and text functions may return that error rather than TRUE or FALSE. Decide how errors should be handled before using a blank test in a larger calculation.
There is also a difference between an empty string and the number zero. A cell containing 0 is not blank, and the equality test against an empty string does not make zero a blank cell. That distinction is useful in numeric models where zero is a meaningful result rather than a missing entry.
Test formulas that return an empty string
A common pattern is an IF formula that displays nothing until a related input exists. For example, with an input in A2, a formula in B2 might return an empty string when A2 has no entry. B2 can look empty while still containing a formula. ISBLANK on B2 therefore returns FALSE, which surprises people who judge only by what they see.
If your goal is to identify cells with no displayed text, an equality test is often more suitable. With the result to inspect in B2, use =B2="". It returns TRUE when B2 is truly empty or when its formula returns an empty string. It returns FALSE if B2 contains visible text or a number. This test does not tell you which of those two blank-like states applies; use ISBLANK when that difference matters.
For instance, a report may need to show “Missing” when a lookup formula has no result, even if the lookup cell contains a formula returning an empty string. In that situation, testing with ISBLANK would miss the displayed-empty result. Testing equality to an empty string captures both cases. Conversely, if you are auditing whether users have entered formulas into required cells, ISBLANK is more informative because it distinguishes a formula from a cell with no content.
Count blank cells in a range
When the question is how many cells are blank rather than whether one cell is blank, COUNTBLANK is the direct option. With the cells to inspect in A2:A20, enter =COUNTBLANK(A2:A20). The result is the number of empty cells in that range. COUNTBLANK also counts cells whose formulas return empty text, so its result can be higher than a count limited to genuinely empty cells.
To count only genuinely empty cells, use SUMPRODUCT with ISBLANK. With the same range, enter =SUMPRODUCT(--ISBLANK(A2:A20)). The double unary converts TRUE and FALSE results to 1 and 0 so SUMPRODUCT can add them. This counts cells that contain nothing, not cells occupied by formulas returning an empty string.
These counts answer different questions, so compare them carefully. If COUNTBLANK returns 7 and the SUMPRODUCT test returns 5, two cells may contain formulas that display empty text. The difference is not necessarily an error; it can reveal how a worksheet is built. A cell with a space will not be included in either count as blank, because it is not empty and does not evaluate to an empty string.
COUNTIF can also be used for blank-like criteria. With the range A2:A20, =COUNTIF(A2:A20,"") counts cells matching an empty-string criterion, including blank cells and formula results that are empty strings. For a straightforward blank count, COUNTBLANK is easier to read; use a more specific approach when you need to separate true emptiness from formula results.
Deal with spaces and invisible characters
If a cell looks blank but fails your test, check for spaces first. With the suspected cell in A1, =LEN(A1) returns the number of characters in its value. If it returns 1 or more while the cell appears empty, the cell may contain a space or another character. You can also click the cell and inspect the formula bar, although some invisible characters remain difficult to identify by sight.
For a cell that may contain ordinary spaces, =LEN(TRIM(A1))=0 returns TRUE if removing ordinary spaces leaves no text. TRIM also reduces repeated spaces between words to a single space, so use this test only when treating ordinary spaces as insignificant is appropriate. Excel’s TRIM function is not a universal whitespace remover: for example, nonbreaking spaces copied from some web pages may remain.
For imported text with common nonprinting characters, a more thorough cleanup test can remove ordinary spaces, certain nonprinting ASCII characters, and the nonbreaking space represented by CHAR(160). With the value in A1, use =LEN(TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160),""))))=0. This can help identify text that becomes empty after those specific characters are removed. It is a cleanup test, not an exact test for a truly empty cell, and removing characters such as line breaks may be undesirable when they carry meaning.
If the data is important, inspect a copy or clean a separate helper column rather than silently changing original values. The right treatment depends on where the data came from and whether spaces or line breaks are meaningful. A practical process is to test, identify affected rows, and then decide whether to trim, replace, or preserve the characters.
Highlight blank cells with conditional formatting
You can make blank cells easier to spot without writing results into a helper column. Select the range to format, such as A2:A20, then choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. With A2 as the first cell in the selected range, enter =ISBLANK(A2), choose a format, and confirm the rule.
The reference should usually be relative to the top-left cell of the selected range. Excel adjusts it for each cell when applying the rule, so a rule based on A2 checks A3 on the next row. If your selection starts at B2, use B2 in the formula instead. Adding dollar signs to lock the reference can cause every cell in a range to be judged by the same cell, which is usually not what you want.
This rule highlights genuinely empty cells only. To highlight cells that are truly empty or contain a formula returning an empty string, use =A2="" with the same range beginning at A2. Conditional formatting changes appearance, not contents: a highlighted cell is not filled with a value, and formatting a cell does not make it nonblank.
Find blank cells and troubleshoot results
When you need to locate empty cells across a worksheet, Excel for Microsoft 365 on Windows has a selection command. Select the area you want to search, then choose Home > Find & Select > Go To Special > Blanks. Excel selects the genuinely blank cells in that selection. The command is useful for reviewing gaps or applying an action to multiple empty cells, but take care if the selection spans a large table: some blank cells may be intentional.
If an ISBLANK test returns FALSE unexpectedly, check the cell’s formula bar, test its length, and consider whether it contains a space or a formula. If a blank count seems too high, look for formulas that return empty strings. If a formula returns an error instead of TRUE or FALSE, inspect the referenced cell for an error value and decide whether your calculation should handle that error separately.
Also check that your test refers to the cell you intend. A copied formula may shift its reference as it moves down a sheet, while an absolute reference stays fixed. For a single-cell check, click the result formula and confirm the reference shown in the formula bar. This simple check catches many apparent formula problems that are really reference problems.
Frequently Asked Questions
Does ISBLANK detect a formula that displays nothing?
No. ISBLANK returns FALSE if the cell contains a formula, even when that formula returns an empty string. Use an equality test such as =A1="" if you want both a genuinely empty cell and an empty-string result to pass.
Is a cell containing a space blank in Excel?
No. A space is a character, so ISBLANK returns FALSE. An equality test against an empty string also returns FALSE for a space. If spaces should be ignored, test a trimmed version of the cell, while remembering that TRIM does not remove every kind of whitespace.
Does COUNTBLANK count formulas that return empty text?
Yes. COUNTBLANK counts genuinely empty cells and cells whose formulas return an empty string. If you need to count only cells with no content, use a SUMPRODUCT and ISBLANK test instead.
How can I test whether a cell is not blank?
For a genuinely nonempty cell, use =NOT(ISBLANK(A1)). This treats a formula returning an empty string as nonblank because the formula occupies the cell. If your definition treats that result as blank, use a test based on whether the cell equals an empty string.
Can formatting make a cell count as blank?
No. Font color, number formats, conditional formatting, and column width can make content hard to see, but they do not erase it. Clear the cell’s contents if you need it to become genuinely empty; use a test that matches the underlying value if you only need to classify it.
Related
- PHP Backend Data Validation: A Practical Guide
- Protect Sheet in Excel: Allow Editing in Certain Cells
- Jira Merge Table Cells: Steps and Limitations
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Hide Excel Columns Based on Cell Values AutomaticallyTo hide Excel columns when a cell contains a chosen value, use a short VBA macro that checks…
- Excel Text to Columns: Split at the First SpaceNo. In Excel for Microsoft 365 on Windows, Data > Text to Columns splits at every space delimiter…
- Excel Page Breaks: How to Set, Move, and Remove ThemTo set a page break in Excel for Microsoft 365 on Windows, select the cell where the next…
- Google Sheets Date Format: How to Turn It On and Set ItTo turn on date formatting in Google Sheets, select the cells you want to format, then choose Format…
- How to Wrap Text in Google Sheets: Settings and TipsTo wrap text in Google Sheets in a web browser, select the cell or range, then choose Format…
- Google Sheets Dropdown Based on Another Cell: GuideYes. In Google Sheets, you can make one dropdown depend on another by creating named ranges for each…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.