Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Map Not Working? Fix the Most Common CausesIf an Excel map is blank, inaccurate, or unavailable, first check that your location data is clear and that you inserted a…
- Excel MATCH Function Not Working? Common FixesIf Excel’s MATCH function is not returning the result you expect, first use an exact-match formula such as =MATCH(E2,A2:A100,0) and check that…
- Excel LET Function Not Working? Fix Common ErrorsIf Excel LET is not working, first confirm you are using Excel 2021 or Microsoft 365, then check the formula’s argument order,…
- Excel Insert Column Not Working? Fix the Common CausesIf Excel will not insert a column, first select the column letter, then choose Home > Insert > Insert Sheet Columns. If…
- Excel INDEX MATCH Not Working With Numbers?Yes—INDEX/MATCH can return the wrong result or #N/A when a lookup number is stored as text, when the formula uses an approximate…
- Excel INDEX MATCH Not Working? Fix the FormulaIf Excel INDEX MATCH is not working, first check that MATCH ends with 0 for an exact match, and that the lookup…
- Excel IFERROR Not Working? Fix Common Formula ProblemsExcel IFERROR usually seems not to work because its first argument is not producing an Excel error, the formula is stored as…
- Excel Hyperlink Not Working After Copying? Causes and FixesIf an Excel hyperlink stops working after you copy it, first check whether the paste kept the hyperlink and whether its destination…
- Excel IF Function Not Working? Fix Common Formula ErrorsIf Excel’s IF function is not working, first check that the formula starts with =IF(, its test compares the values you intended,…
- Excel Hyperlink Not Working? How to Fix ItIf an Excel hyperlink is not working, first check how Excel expects you to open it: in Microsoft 365 for Windows, hold…
- Excel Freeze First Column Not Working? Causes and FixesIf Excel’s first column will not stay visible while you scroll, choose View > Freeze Panes > Freeze First Column on Windows.…
- Excel Group Columns Not Working? Fix the OutlineIf Excel will not group columns, select the columns you want, then choose Data > Outline > Group. If the command is…
- Excel Find Not Working? Fix Search and Find SettingsIf Excel Find is not working, press Ctrl+F, open Options, and check the search scope and Look in setting; then turn off…
- Excel Freeze Columns Not Working? Fix the ViewIf Excel freeze columns are not working, select the cell immediately to the right of the columns you want to keep visible,…
- Excel Find and Replace Not Working? Fix the Common CausesIf Excel Find and Replace is not working, first check the search scope and the options in the Replace dialog: press Ctrl+H,…
- Excel Find Not Working? Fix Search Problems in a WorksheetIf Excel’s Find feature is not working, first open Home > Find & Select > Find, expand the options, set Within to…
- Excel Filter Not Working After a Certain Row? Fix ItIf Excel filtering stops at a certain row, the filter range usually ends there—often because a completely blank row separates the data,…
- Excel Filter Shortcut Keys Not Working? Fixes to TryIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off. If nothing happens, select a cell in…
- Excel Find and Replace Not Working? Causes and FixesIf Excel Find and Replace is not working, check the search scope, the “Look in” setting, and whether a format or whole-cell…
- Excel Filter Button Not Working? Fix Common CausesIf the Excel filter button is missing, greyed out, or not filtering the rows you expect, check that your data has one…
- Excel FILTER Function Not Working? Fix Common CausesIf Excel’s FILTER function is not working, first confirm you are using Microsoft 365 or Excel 2021 or later, then check that…
- Excel Hyperlink Not Working? Fix Links and Common CausesIf an Excel hyperlink is not working, first check whether Excel requires Ctrl+click, then verify the link’s destination and access permissions. In…
- Excel Filled Map Not Working? Fix These Common IssuesIf Excel’s Filled Map is not working, the usual causes are unrecognized or ambiguous location names, an unsupported Excel version, or a…
- Excel Filter A to Z Not Working? Fix the SortIf Excel’s A to Z command is not sorting the records you expect, first click a cell in the column you want…
- Excel Double-Click Column Width Not Working?If double-clicking an Excel column boundary does not resize the column, first double-click the right edge of its letter heading—not the cell…
- Excel Filter Not Working? Fix the Most Common CausesIf an Excel filter is not working, first check that it covers the complete data range and that the header row is…
- Excel Data Filter Not Working? Fix the Common CausesIf an Excel filter is not working, first check that the filter covers the entire data range, that the first row contains…
- Excel Date Value Not Working? Causes, Checks, and FixesIf an Excel date value is not working, first check whether the cell contains a real date or text that merely looks…
- Excel COUNTIFS Date Range Not Working? Fix the CriteriaIf Excel COUNTIFS is not counting dates in a range, first make sure the cells contain real Excel dates, then use criteria…
- Excel COUNTIFS Not Working? Fix Common Formula ErrorsWhen Excel COUNTIFS is not working, first check that every criteria range has the same shape, then confirm that the criteria actually…