Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Sort Expand Selection Not Working? Try These FixesIf Excel’s Expand the selection option is not working, cancel the sort, select the entire data range—including every column that belongs to…
- Excel Filter Not Applying to All Rows? How to Fix ItIf an Excel filter is not applying to all rows, its selected range probably stops before the remaining data—often at a blank…
- INDIRECT Excel Not Working? Fix the ReferenceIf INDIRECT is not working, check that its text builds a valid cell reference, that the referenced sheet or workbook is available,…
- Excel Not Responding? Fix It Without Losing Your SaveIf Excel says “Not Responding,” don’t force-quit it straight away: wait briefly, avoid clicking repeatedly, and try saving with Ctrl+S if the…
- Excel Not Responding on Windows 11? Fix It SafelyIf Excel says “Not responding” on Windows 11, first give it a moment—large calculations or files can temporarily occupy the app—then check…
- Excel Not Selecting Cells Properly? Find the Right FixIf Excel is not selecting cells properly, press Esc and check whether a selection mode such as Extend Selection or Add to…
- SUMPRODUCT Excel Not Working? Fix Common ErrorsIf SUMPRODUCT is not working, first check that every range has the same number of rows and columns, then look for errors,…
- SUMPRODUCT Excel #DIV/0! Error: Causes and FixesYes—SUMPRODUCT returns #DIV/0! when its calculation divides a value by zero, or when an input cell already contains that error. Check the…
- Excel SUM Not Working? Fix Common Formula ProblemsIf Excel SUM does not work, first check that the formula starts with an equals sign, covers the intended cells, and is…
- Excel Not Opening CSV Correctly? How to Fix ItIf Excel is not opening a CSV correctly, import it instead of double-clicking the file: in Excel for Microsoft 365 on Windows,…
- Excel Not Recognizing Dates? Fix Text and Format IssuesIf Excel is not recognizing dates, check whether the cell contains a real date value or text: apply Home > Number Format…
- Excel Not Letting You Type in a Cell? How to Fix ItIf Excel will not let you type in a cell, first check whether the worksheet is protected, the file is read-only, or…
- YEAR Function in Excel Not Working? Fixes That HelpIf Excel’s YEAR function is not working, first check that its argument is a real Excel date, not text or a number…
- Excel New Line in Cell: Add Line Breaks and Fix ThemTo start a new line inside an Excel cell, edit the cell, place the cursor where the break should go, and press…
- TRIM Excel Not Working? Fix Spaces That TRIM MissesIf TRIM appears not to work in Excel, the text may contain a character that TRIM does not recognize as a regular…
- Excel Freeze Panes Not Working? Fix the SelectionIf Excel is not freezing the rows or columns you selected, click the cell immediately below the rows and to the right…
- Excel Not Letting You Filter? Fix the Common CausesIf Excel is not letting you filter, first select a cell in the data and choose Data > Sort & Filter >…
- Excel Not Filling Sequential Numbers? Fix the SeriesIf Excel repeats a number instead of counting, enter the first two numbers, select both cells, and drag the fill handle down…
- Excel Not Dragging Down Numbers? Fix the Fill HandleIf Excel repeats a number instead of counting up, select the first two numbers in the pattern and drag the fill handle…
- XLOOKUP Excel Not Working? Fix Common Errors and CausesIf XLOOKUP is not working, first check that your Excel version supports it, then confirm the lookup and return ranges line up…
- VLOOKUP in Excel: Find Matching Values and Fix ErrorsTo find a matching value in Excel, use VLOOKUP with an exact-match setting. For example, if IDs are in A2:A6, department names…
- Excel Not Copying and Pasting Correctly? Fix ItIf Excel is not copying and pasting correctly, first press Esc, select the source cells again, press Ctrl+C, click one destination cell,…
- TEXTJOIN in Excel Not Working? Common FixesIf TEXTJOIN in Excel is not working, first check that the function is spelled TEXTJOIN, your Excel version supports it, and your…
- Excel Not Converting to Number? Fix Text-Formatted ValuesIf Excel is not converting a value to a number, first select the affected cells and use the warning icon that appears…
- Excel Not Auto Filling Text? Fix the Common CausesIf Excel is not auto-filling text, check the feature you mean: turn on AutoComplete for suggestions based on entries already in a…
- Excel Not a Number? Understand #NUM! and ISNUMBERIn Excel, “not a number” can refer to the #NUM! error, which means a formula cannot produce a valid numeric result, or…
- Excel Not Allowing Copy and Paste? How to Fix ItIf Excel is not allowing copy and paste, press Esc, select a normal cell, and try Ctrl+C followed by Ctrl+V; if it…
- Excel IFS Error? Common Causes and FixesWith a score in A2, an IFS formula needs a final fallback if every test might be false: =IFS(A2>=90,"A",A2>=80,"B",TRUE,"F"). If Excel shows…
- Excel Not Working? Fixes for Common ProblemsIf Excel is not working, first save a copy of your workbook if you can, close and reopen Excel, and check whether…
- XLOOKUP Excel IF ERROR: Fix Missing Matches and ErrorsTo show a friendly result when XLOOKUP cannot find a match, use its fourth argument: with lookup value in D2, codes in…