Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Not Highlighting Rows? Fix the Selection and RulesIf Excel is not highlighting rows, first check whether you are selecting the row or expecting a formatting rule to color it:…
- Excel Not Grouping Rows? Fix Outlines and Data IssuesIf Excel is not grouping rows, select the rows or cells you want to outline and choose Data > Outline > Group,…
- Excel Not Highlighting Columns? Fix Selection IssuesIf Excel is not highlighting a column, click its lettered heading at the top of the worksheet, or select a cell in…
- Excel Not Getting Data? Fix Queries, Imports, and LinksIf Excel is not getting data, first open the Data tab and select Refresh All; then check that the source file, connection,…
- Excel Not Giving Correct Sum? Find and Fix the CauseIf Excel is not giving the correct sum, first check that the formula includes the intended cells, that the values are real…
- Excel Not Calculating a Formula Just Written? Fix ItIf Excel is not calculating a formula you just wrote, first check that calculation is set to Automatic: go to Formulas >…
- Excel Not Copying and Pasting All Data? Fix ItIf Excel is not copying and pasting all your data, first check whether a filter, hidden rows, or an incomplete selection is…
- Excel Not Copying Formula When Dragging? How to FixIf Excel is not copying a formula when you drag, first check that the fill handle is enabled: in Windows, go to…
- Excel CONCAT to Remove a File Name SuffixCONCAT in Excel joins text; it does not remove a file-name suffix by itself. To remove the last extension, use =IFERROR(TEXTBEFORE(A2,".",-1),A2) when…
- Excel Not Wrapping Text? Fix the CellIf Excel is not wrapping text, select the affected cell or cells and choose Home > Wrap Text. If the text still…
- Excel Formulas Not Updating Automatically? Fix ItIf Excel formulas are not updating automatically, set calculation to Automatic: go to Formulas > Calculation Options > Automatic. If that does…
- Excel Not Sorting Correctly? Fix Common CausesExcel usually sorts incorrectly because it is sorting only part of a table, treating numbers or dates as text, or interpreting a…
- Excel Not Taking Formula? Fix the Cell or CalculationIf Excel is not taking a formula, first check whether the cell is formatted as Text: set it to General, then re-enter…
- Excel Not Running Formula? Fix Calculation and Cell IssuesIf Excel is not running a formula, first check Formulas > Calculation Options > Automatic, then confirm the cell contains a formula…
- Excel Not Showing Sum at Bottom? Fix the Status BarIf Excel is not showing a sum at the bottom, select the cells you want to total and make sure Sum is…
- Excel Not Removing Duplicates? Fix Common CausesIf Excel is not removing duplicates, first check that you selected the full data range and the correct columns in Data >…
- Excel Not Reading Dates as Dates? Fix the Cell ValuesIf Excel is not reading a date as a date, the cell usually contains text that only looks like a date. In…
- Excel Not Recognizing Numbers? Fix Text-Formatted CellsExcel usually fails to recognize numbers because the cells contain text that looks numeric, often after a paste or file import. Select…
- Excel Not Printing All Columns? Fix the Page SetupIf Excel is not printing all your columns, check the print area first, then set the worksheet to fit one page wide:…
- Excel Not Printing All Rows? Fix the Print SettingsIf Excel is not printing all rows, check that File > Print is not set to print only a selection or a…
- Excel Not Pasting Data Correctly? Fix Common CausesIf Excel is not pasting data correctly, press Esc to leave cell-edit mode, select the intended top-left destination cell, and try Home…
- Excel Arrow Keys Not Moving Cells? Fix the CauseIf the arrow keys scroll the worksheet instead of moving the selected cell, turn off Scroll Lock: press the Scroll Lock (ScrLk)…
- Excel Not Inserting Rows? Fix the Most Common CausesIf Excel is not inserting rows, first select the worksheet row header where the new row should go, then choose Home >…
- Excel Not Letting Me Drag Formulas? Fix the Fill HandleIf Excel will not let you drag a formula, first check that the fill handle is enabled: go to File > Options…
- Excel Not Incrementing Cells When Dragged? How to FixIf Excel is not incrementing cells when you drag, it may be copying the selected value instead of extending a series. For…
- Excel Not Increasing Numbers When Dragging? Fix ItIf Excel repeats a number instead of counting up when you drag the fill handle, select the starting number and choose Auto…
- Excel Not Formatting Dates? How to Fix the ProblemIf Excel is not formatting a date, first check whether the cell contains a real Excel date or text that only looks…
- Excel Not Finding Duplicates? Fix the Common CausesExcel may not be finding duplicates because the rule is checking the wrong range, the entries only look alike, or the cells…
- Excel Not Filtering All Rows? Find and Fix the CauseIf Excel is not filtering all rows, the filter may cover only part of your data, or a blank row or column…
- Excel Not Evaluating Formula? Fix Common CausesIf Excel is not evaluating a formula, first select Formulas > Calculation Options > Automatic, then check that the cell is not…