Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Repair Excel in Windows 10: Fix Common Excel ProblemsTo repair Excel in Windows 10, first restart your PC and check whether Excel opens in Safe Mode; if it still fails,…
- How to Repair an Excel File That Won’t Open SafelyIf an Excel file will not open, first make a copy of it, then use Excel for Microsoft 365 on Windows: choose…
- Excel SUMPRODUCT: How to Use It and Fix Common ErrorsTo get SUMPRODUCT working in Excel, make sure the ranges you want to multiply have matching dimensions, then enter a formula such…
- Excel XLOOKUP Spill Error: Fix the #SPILL! MessageTo fix an Excel XLOOKUP #SPILL! error, select the cell showing the error, use the warning icon to identify what is blocking…
- Excel SUMIF Spill Error: Causes and How to Fix It QuicklyTo fix an Excel SUMIF #SPILL! error, either clear the cells blocking the formula’s output or change the formula so it returns…
- Excel SUM Formula Not Working? Fix It Step by StepIf an Excel SUM formula shows zero, leaves out values, or does not update, first check that the formula points to the…
- How to Fix #N/A in Excel VLOOKUP: Causes and FixesTo fix a #N/A error in Excel VLOOKUP, first make sure the formula searches the correct first column, then use FALSE for…
- Excel VLOOKUP #SPILL! Error: How to Fix It Step by StepTo fix a #SPILL! error in Excel VLOOKUP, first check whether the formula is trying to return results for several lookup values.…
- Excel Repair: Fix Errors and Recover a Damaged WorkbookIf Excel reports a problem with a workbook, first make a copy of the file, then use Excel for Microsoft 365 on…
- Fix an Excel PivotTable Spill Error: Causes and StepsTo fix a #SPILL! error near an Excel PivotTable, select the error cell, use its warning menu to find obstructing cells, and…
- How to Find Invalid Formulas in Excel and Fix ErrorsTo find invalid formulas in Excel, select the worksheet and choose Home > Find & Select > Go To Special, select Formulas…
- How to Extend a Filter Range in Excel Without Missing RowsTo extend a filter range in Excel, include all the data rows and columns in the range, then apply Data > Filter…
- How to Clean Names in Excel: Fix Spaces, Case, and MoreTo clean names in Excel, keep the original list, then use a formula to remove extra spaces and hidden characters and apply…
- Calculate Error in Excel: Formulas and ExamplesTo calculate the difference between an expected value and a measured value in Excel, subtract the expected value from the measured one;…
- Help With Excel Errors: Find and Fix Common ProblemsTo get help with an Excel error, read the error code, check the formula and its referenced cells, then fix the underlying…
- Excel Formula Not Working? Fix Cells Showing FormulasIf Excel shows the formula itself instead of its result, first turn off Formulas > Formula Auditing > Show Formulas, then check…
- Excel Formula Not Working? Common Causes and FixesIf a formula is not working in Excel, first check whether the cell is formatted as Text, calculation is set to Manual,…
- Excel Formula Is Correct but Not Working? How to Fix ItIf a formula is correct but not working in Excel, first check whether the cell is formatted as Text, calculation is set…
- Fix Excel Spill Error in a Table: Causes and SolutionsTo fix a #SPILL! error in an Excel table, move the dynamic-array formula into a regular worksheet cell outside the table, where…
- Find Missing Names in Two Excel Columns with a FormulaTo find names in column A that do not appear in column B, enter this formula in an empty cell: =FILTER(A2:A100,(A2:A100<>"")*(COUNTIF(B2:B100,A2:A100)=0),"No missing…
- Excel Find and Replace in Formulas: Fix Common ProblemsIf Find and Replace is not finding text inside Excel formulas, press Ctrl+H, open Options, and set Look in to Formulas; also…
- Excel Filter Database Error: Causes, Checks, and FixesIf Excel reports that the database or list range is not valid while you use Advanced Filter, check that the selected list…
- Excel Zoom Slider Not Working? Causes and FixesIf the Excel zoom slider is missing or will not change the worksheet view, right-click the status bar and check whether Zoom…
- Excel Zoom Not Working? Fix the View and Zoom ControlsIf Excel zoom is not working, select a worksheet cell and use View > Zoom or the zoom slider at the bottom-right…
- Excel Yes/No Formula Not Working? Common Causes and FixesIf an Excel yes/no formula is not working, check that the formula points to the right cell, uses the correct comparison, and…
- Excel Can’t Paste Here: Fix the Copy Area ErrorExcel shows “You can’t paste here because the copy area and paste area aren’t the same size and shape” when the copied…
- Excel XLOOKUP Value Not Available Error: How to FixIn Excel, XLOOKUP’s “value not available” message usually means it could not find the lookup value; the formula displays this as #N/A…
- Excel XLOOKUP Name Error? Causes and FixesAn Excel XLOOKUP #NAME? error usually means Excel does not recognize the XLOOKUP function or another name used in the formula. Check…
- Excel XLOOKUP #N/A Error? Causes and FixesAn XLOOKUP formula returns #N/A when it cannot find its lookup value in the lookup array, or when the matched result itself…
- Excel XLOOKUP #N/A Error: Causes and FixesIf XLOOKUP returns #N/A, Excel usually cannot find the lookup value in the lookup range. With the value to find in E2,…