Excel cells look empty but aren't — COUNTA, filters and Go To Blanks fail

Find invisible spaces and empty text that make blank cells behave like filled ones.

The message you see
Blank cells are not empty (COUNTA counts them)
Fastest fix

Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.

Remove truly blank rows →

Why this happens

How to fix it

  1. 1Use =LEN(A2) to reveal hidden characters.
  2. 2Trim spaces across the file, then remove rows that are truly empty.

Related guides

Still stuck? Ask SheetFix Support