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.
Why this happens
- Cells contain spaces or non-breaking spaces.
- Formulas returned "" and were pasted as values.
How to fix it
- 1Use =LEN(A2) to reveal hidden characters.
- 2Trim spaces across the file, then remove rows that are truly empty.
Related guides
Excel
“Excel cannot open the file because the file format or file extension is not valid”
ExcelExcel error “SYLK: File format is not valid” when opening a CSV
Excel“We found a problem with some content” — Excel workbook won't open properly
Still stuck? Ask SheetFix Support