Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Autofit Row Height Adding Extra Line? FixYes, Excel’s autofit row height can add an extra line of space, and the most common cause is that the row contains…
- Excel and CSV Icons: What They Mean & How to Fix ThemThe icons you see next to Excel and CSV files are file-type associations—they tell Windows which program should open the file when…
- JS split is not a function? Fix It Fast“JS split is not a function” means you called .split() on a value that is not a string. The fix: convert the…
- JavaScript split Is Not a Function: Causes and Fixessplit() is a JavaScript string method, so “split is not a function” usually means your code is calling it on a value…
- EaseUS Excel Repair: What It Can Fix and How to Use It SafelyYes. EaseUS Fixo is EaseUS’s file-repair product for damaged documents, including Excel workbooks, and may help when a file will not open…
- DATEDIF in Excel: Why It’s Missing and How to Use ItYes—DATEDIF is a working Excel function, even though Excel may not suggest it as you type or list it with other functions.…
- DATEDIF in Excel: Why It’s Missing and How to Use ItYes—DATEDIF is available in Microsoft Excel, even though it may not appear in the function list or autocomplete. Enter it directly in…
- Data Validation Missing in Excel? How to Restore ItIf Data Validation is missing in Excel, first check that you are using the desktop app and look under Data > Data…
- Data Validation in Excel: Why It Is Missing and FixesYes—Data Validation is available in Excel for Microsoft 365 on Windows. Find it on the Data tab, in the Data Tools group,…
- COUNTIF in Excel Not Counting Correctly? How to Fix ItIf COUNTIF in Excel is not counting correctly, check the criteria, the cell contents, and the range first: extra spaces, wildcard characters,…
- COUNTIF Duplicates in Excel: Examples and Ways to Fix ThemTo count how often a value appears in Excel, enter =COUNTIF($A$2:$A$7,A2) beside your list and fill it down. With product names in…
- Can’t Close Excel? Fix a Frozen or Stuck App on WindowsIf you can’t close Excel, first press Esc to dismiss a possible dialog, then try Alt+F4 to close the active window; save…
- Wrap Text in Excel: How It Works and How to Fix ItYes. In Excel for Microsoft 365 on Windows, select the cell or cells, then choose Home > Alignment > Wrap Text; Excel…
- Is Excel Null? Blank Cells and Missing ValuesNo: Microsoft Excel does not have a general worksheet value called NULL. A cell can be genuinely empty, contain a formula that…
- Excel Is Not Null? Understanding Blank ValuesNo. A normal Excel worksheet cell does not contain a SQL-style NULL value: it can be truly empty, contain a formula that…
- Excel Is Not Zero: Filter, Count, and Test Cell ValuesIn Excel, “is not zero” means a value is anything other than numeric 0. Use the not-equal operator <>
- Analysis ToolPak Not Showing in Excel? Fix ItIf the Excel Analysis ToolPak or its Data Analysis button is missing, enable the add-in in desktop Excel: go to File >…
- How to Trace Circular References in Excel and Fix ThemTo trace a circular reference in Excel for Microsoft 365 on Windows, go to Formulas > Error Checking > Circular References, then…
- Typing a Formula in Excel but It Is Not Calculating?If a formula you type in Excel is not calculating, first check that the cell is not formatted as Text: change its…
- Remove a Circular Reference in Excel: Find and Fix ItTo remove a circular reference in Excel for Microsoft 365 on Windows, go to Formulas > Error Checking > Circular References, select…
- Remove Duplicates in Excel Grayed Out? Fix ItIf Remove Duplicates is grayed out in Excel for Microsoft 365 on Windows, first exit cell-edit mode and select a cell in…
- Excel Formula Not Calculating? Fix the Common CausesIf an Excel formula is not calculating, first check Formulas > Calculation Options > Automatic, then make sure the cell is not…
- Office 365 Excel Formula Not Calculating? How to FixIf an Office 365 Excel formula is not calculating, first check Formulas > Calculation Options and select Automatic. If the result still…
- Excel CSV Import: Open and Fix Files in Microsoft 365To import a CSV file into Excel for Microsoft 365 on Windows, select Data > Get Data > From File > From…
- Excel Circular References: Find, Fix, and Understand ThemA circular reference in Microsoft Excel happens when a formula refers to its own cell, either directly or through a chain of…
- Locate Circular References in Excel: Find and Fix ThemIn Excel for Microsoft 365 on Windows, select Formulas > Error Checking > Circular References to see listed cells that participate in…
- Circular Reference in Excel: How to Locate and Fix ItTo locate a circular reference in Excel for Microsoft 365 on Windows, select Formulas > Error Checking > Circular References, then click…
- Insert Option Greyed Out in Excel? How to Fix RowsIf Excel’s Insert option is greyed out when you want to add a row, first press Esc, check that the sheet is…
- How to Verify an Excel File Is Not Corrupted SafelyTo check whether an Excel file is corrupted, first make a separate copy, then open the workbook in desktop Excel and confirm…
- Excel Not Responding: How to Fix ItIf Excel says Not Responding, wait briefly before closing it, especially if the workbook is large or performing a calculation. If it…