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 →
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.