Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Fit All Columns on One Page in Excel Not Working?If Fit All Columns on One Page is not working in Excel, check the active sheet’s scaling, print area, and paper settings.…
- Excel Filter Not Working? Fix Common ProblemsIf Excel’s Filter option is not working, first select a cell in the full data range and choose Data > Filter; then…
- Find Option Not Working in Excel? Causes and FixesIf Find is not working in Excel, press Ctrl+F, open Options in the Find dialog, and check the search scope and what…
- Find Tool Not Working in Excel? Fix Find and ReplaceIf Excel’s Find tool is not working, press Ctrl+F, open Options in the Find and Replace dialog, and check the search scope…
- Excel Filter Not Working? Fix the Most Common CausesIf an Excel filter is not working properly, first check that it covers the entire data range and that each column has…
- Excel Filter Not Working With Merged Cells? Fix ItIf Excel’s filter is missing, disabled, or returning confusing results around merged cells, unmerge the cells in the list—especially in its header…
- Excel Filter Not Working? Causes and Fixes That HelpIf a filter in Excel is not working, first check that the filter covers the full data range, then clear existing criteria…
- Excel Filter Not Working With Merged Cells? Fix ItIf Excel’s filter is missing, disabled, or giving unreliable results around merged cells, unmerge the cells inside the data range and give…
- Excel Filter Not Working? Common Causes and Fixes GuideIf a filter in Excel is not working, first check that it covers the entire data range, that the column contains values…
- Excel Filter Not Working for All Rows? Find the CauseIf Excel’s filter is not working for all rows, its filter range may stop before the missing records, or another issue—such as…
- Excel Online Filter Not Working? Fix Common CausesIf a filter is not working in Excel Online, select a cell in the data and choose Data > Filter; then check…
- Excel Filter Not Working in SharePoint? Causes and FixesIf a filter is not working in Excel in SharePoint, first check that the filter covers the full data range, then clear…
- FILTER Formula Not Working in Excel? Fixes That WorkIf the FILTER formula is not working in Excel, first check that your Excel version supports dynamic arrays, the include range has…
- Excel Filter Not Working? Fix the Most Common CausesIf an Excel filter is missing rows, showing unexpected results, or not responding, first check that the filter covers the entire data…
- F4 Dollar Sign in Excel Not Working? Causes and FixesIf F4 will not add dollar signs to a cell reference in Excel for Microsoft 365 on Windows, first make sure you…
- Excel Filter Dropdown Not Working? Fix Common CausesIf an Excel filter dropdown is missing, will not open, or shows the wrong results, first select a cell in the data…
- Excel YEAR Function Not Working? Fix Dates and ResultsIf Excel’s year-today formula is not working, enter =YEAR(TODAY()) in a cell formatted as General or Number; it should return the current…
- Extract Year from Date in Excel: Fix Common ErrorsIf extracting a year from a date in Excel is not working, first check that the cell contains a real Excel date,…
- Excel YEAR Formula Not Working? Fix Dates and ErrorsIf the YEAR formula is not working, first check whether the cell contains a real Excel date rather than text. With a…
- Excel YEAR Function Not Working? Fix Dates and ResultsIf Excel’s YEAR function is not working, first check whether the referenced cell contains a real Excel date or text that only…
- Excel VLOOKUP Not Working? Common Causes and FixesExcel VLOOKUP usually fails because the lookup value does not exactly match the first column of the selected range, the formula points…
- Excel Filter Not Working? Common Causes and FixesWhen an Excel filter is not working, the cause is usually an incomplete data range, a blank or confusing header row, a…
- Excel Weekday Formula Not Working? Causes and FixesIf an Excel weekday formula is not working, first check that the cell contains a real Excel date, then use =WEEKDAY(A2,2) to…
- Excel WEEKDAY Function Not Working? Fix Common CausesIf Excel’s WEEKDAY function is returning an error or an unexpected number, first confirm the cell contains a real date and that…
- Excel VLOOKUP Not Working? Fix the Common CausesIf Excel VLOOKUP is returning the wrong result or an error, first set its final argument to FALSE for an exact match,…
- Excel VLOOKUP Not Working With Numbers? Fix the MatchWhen VLOOKUP cannot find a number, the most common cause is that one value is a real number and the other is…
- Excel VLOOKUP Not Working With Text? Fix the MatchIf VLOOKUP is not finding text in Excel, first use an exact match and check that the lookup value and the first…
- Excel VLOOKUP Not Working? Fix the Common CausesIf VLOOKUP is returning an error or the wrong result, check that the lookup value is in the first column of the…
- Excel VLOOKUP Not Working for One Column? How to Fix ItIf VLOOKUP works for other return columns but fails for one, check that column’s index number, the lookup values and the source…
- Excel VLOOKUP Not Working? Fix the CauseIf VLOOKUP is not working in Excel, check that you are using the right match mode, that the lookup value and first…