Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Unhide Rows in Excel Not Working? Fix the Hidden RowsIf Unhide does nothing in Excel, select the row headers on both sides of the missing rows, right-click the selection, and choose…
- Filter by Color in Excel Not Showing? Fix ItIf Filter by Color is missing in Excel, open the filter arrow on the column that actually contains the colored cells and…
- COUNTA Excel Not Working? Find the CauseIf COUNTA seems wrong, first check what is actually in the cells: the function counts any nonempty cell, including formulas that display…
- Excel IRR #DIV/0! Error: Why It Happens and How to FixIf Excel shows #DIV/0! beside IRR, the error is usually in one of the cash-flow formulas or cells: IRR normally reports #NUM!…
- Excel NPV Errors: Why Results Look Wrong and How to Fix ThemExcel NPV errors most often come from including the initial investment in the wrong place, using a discount rate that does not…
- Excel Won’t Let You Delete a Row? Try These FixesTo delete a worksheet row in Excel for Microsoft 365 on Windows, select its numbered heading, then choose Home > Delete >…
- Excel LET Not Working? Common Errors and How to Fix ThemExcel LET usually fails because the installed Excel version does not support it, the formula has the wrong argument structure, or a…
- Excel UNIQUE Spill Error: Causes, Fixes, and ExamplesIf Excel shows #SPILL! for a UNIQUE formula, it means Excel cannot place the formula’s results in the cells it needs. Clear…
- Excel Not Working on Mac? Fixes for Common ProblemsIf Excel is not working on your Mac, first check whether the problem affects the app, one workbook, or your Microsoft 365…
- Excel Not Working in Windows 11? Fix Common ProblemsIf Excel is not working in Windows 11, first restart the computer, check whether Excel opens in Safe Mode, and install any…
- Excel Not Working Properly? Troubleshoot Common IssuesIf Excel is not working properly, first save a copy of your workbook, close and reopen Excel, and check whether the problem…
- Excel Not Typing in Cell? Fix the Common CausesIf Excel will not let you type in a cell, first select the cell and try entering text in the formula bar;…
- 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…