Solution Library
Excel Error Guides
In-depth guides for every spreadsheet issue our tool detects — with step-by-step fixes, real examples, and prevention tips.
How to Fix #REF! Errors in Excel
Step-by-step guide to understanding, finding, and permanently fixing broken cell references in Excel.
Read guide →
How to Fix #N/A Errors in Excel
Fix #N/A in VLOOKUP, MATCH, and XLOOKUP — data type mismatches, spaces, missing values, and more.
Read guide →
How to Fix #NAME? Errors in Excel
Every cause of #NAME? — misspelled functions, undefined names, missing quotes — with exact fixes.
Read guide →
How to Fix #DIV/0! Errors in Excel
Why #DIV/0! appears, the three real causes (empty cells, zero denominators, AVERAGE on blanks), and how to fix or safely suppress each.
Read guide →
How to Fix #NUM! Errors in Excel
Fix #NUM! from invalid SQRT/LOG arguments, out-of-range results, and iterative functions like IRR and RATE that fail to converge.
Read guide →
How to Fix #NULL! Errors in Excel
The rarest Excel error — caused by the space (intersection) operator on non-overlapping ranges. Almost always a missing comma.
Read guide →
Fix Numbers Stored as Text in Excel
Detect and bulk-convert text-formatted numbers that silently break SUM, VLOOKUP, and AVERAGE.
Read guide →
How to Find Hidden Sheets in Excel
Discover both "hidden" and "very hidden" sheets — including ones that cannot be found with a right-click.
Read guide →
How to Fix Broken External Links in Excel
Find all formulas referencing other workbooks and repair them before they silently corrupt your data.
Read guide →
How to Find Hardcoded Values in Excel Formulas
Identify and replace magic numbers embedded in formulas with maintainable named ranges or input cells.
Read guide →
How to Fix Inconsistent Formulas in Excel Columns
Detect cells that break the formula pattern of their column — the silent cause of wrong calculation totals.
Read guide →
How to Reduce Excel File Size
Fix phantom used ranges, column-wide conditional formatting, and embedded images — the most common causes of oversized .xlsx files.
Read guide →
How to Merge Excel Files Without Losing Data
Combine multiple workbooks into one using Power Query, VBA, or a free browser tool — with row-count verification to confirm nothing was dropped.
Read guide →
How to Split an Excel File Into Multiple Files
Divide one large workbook into separate files or sheets by column value — by region, department, month, or any category.
Read guide →
Find errors automatically
Upload your spreadsheet and our tool will detect all these issues instantly — with detailed explanations for each one found.