Post actualizado el día octubre 24, 2026 by DeiviSanzPlay
You open the file, the column that yesterday showed amounts appears empty, and the total keeps adding up as if the data existed. Before restoring a backup or redoing the sheet, go through this checklist in order. Most cases of Excel cells turning blank are resolved in the first four points.
1. Check whether the content is hidden, not deleted
It’s the first suspect and the most frequent. Click on the column header, go to Home → Format → Hide & Unhide → Unhide Columns. If the text reappears, you had columns with zero width. This happens a lot when pasting data from another file or when accidentally dragging the border.
Also check the font color: select the range and apply Font → Automatic Color. Conditional formatting with white fill and white font produces the same visual effect as an empty cell.
2. Verify the custom number format
A format like ;;; hides any value without deleting it. Select the cell, press Ctrl+1, and look at the Custom category. If you see three semicolons, change it to General. This trick is used on purpose in templates to hide figures and then gets inherited when copying the sheet.
3. Rule out rows and cells hidden by filter
If the cell exists but isn’t visible, it may be inside a filtered row. Check the funnel icon in the headers and click Clear Filter. In tables with slicers, the filter may still be active even though the table looks complete.
4. Check references and calculation mode
When a formula returns empty, it’s not that the cell has been deleted: it’s returning an empty string. Look for functions like IFERROR, VLOOKUP with a failed exact match, or IF(A1=»»,»»,…). Type =ISBLANK(A1) in a helper cell: if it returns FALSE but you see nothing, the problem is formatting, not content.
Also check Formulas → Calculation Options. In manual mode, results don’t update until you press F9, and a cell with a formula can appear empty after a data change.
5. Suspect CSV and text import
When opening a CSV with different delimiters, Excel may place the values in adjacent columns and leave the original one apparently empty. Use Data → Text to Columns and check the separator before giving the content up for lost. A typical case: semicolon-separated exports from Spanish-language systems that Excel interprets as commas.
6. Values that Excel interprets as empty text
A space, a leading apostrophe, or a non-printable character (for example, the line break introduced by pasting from a website) make the cell appear empty in the preview. Selecting the range and applying Find and Replace with an empty search field doesn’t work; instead, use =TRIM(A1) or =CLEAN(A1) in a helper column to detect residue.
7. Check sheet and workbook protection
A protected sheet prevents editing, but doesn’t delete. If the cells appear blank when you try to type, check Review → Unprotect Sheet. If you’ve forgotten the password, Microsoft’s official documentation warns that there is no built-in recovery: you’ll have to rebuild the file or use third-party tools at your own risk.
8. Last resort: recovery and versions
Before overwriting, look for copies in File → Info → Manage Workbook or in version history if the file is on OneDrive or SharePoint. According to the official documentation, AutoRecover only acts after an unexpected close, not after a saved manual deletion.
Honest limitation: this list covers display and formatting causes. If the content has been deleted and the workbook was saved, none of these checks will bring it back; only backups or cloud history will. And if the file comes from a macro that clears ranges when opened, the problem will recur until you review the VBA code, something this checklist doesn’t resolve.
Recommended order of checks
- Unhide hidden columns and rows.
- Custom number format.
- Active filters.
- Calculation mode and formulas that return an empty string.
- CSV import.
- Invisible characters.
- Sheet protection.
- Version history and backups.
With this walkthrough, the cause is located in most files without needing to touch the original data. If the problem persists after point 4, it’s advisable to duplicate the sheet before continuing to test.
