Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Conditional Formatting: Apply Rules and Fix IssuesTo apply conditional formatting in Excel for Microsoft 365 on Windows, select the cells, then choose Home > Conditional Formatting and pick…
- Excel Data Validation Not Showing? Fix the DropdownIf Excel’s data-validation dropdown is not showing, select the cell and check Data > Data Tools > Data Validation > Settings: set…
- Compare Two Excel Sheets for Missing Data: A Practical GuideTo compare two Excel sheets for missing data, match records using a shared key—such as an ID or email address—and check whether…
- Circular References in Excel: How to Find and Fix ThemA circular reference in Excel is a formula that refers, directly or through other formulas, back to its own cell. In Microsoft…
- Excel Not Responding: How to Fix It Safely on WindowsWhen Excel shows “Not Responding,” first wait briefly in case it is calculating or loading a large file; then try Esc to…
- Flash Fill in Excel: How to Use It and Fix ProblemsTo use Flash Fill in Excel for Microsoft 365 on Windows, type the result you want beside your source data, then press…
- Can’t Insert a Row in an Excel Table? Fix ItIf you can’t insert a row in an Excel table, first click a cell inside the table, right-click the row, and choose…
- Can’t Hyperlink in Excel? Create and Fix LinksYes, you can add clickable hyperlinks in Excel to websites, files, email addresses, and places in a workbook. In Microsoft 365 for…
- Can’t Insert a Row in Excel? Fix the Common CausesIf you can’t insert a row in Excel, first select the row number where the new row should go, then choose Home…
- Transpose Not Showing in Excel? Fix the Missing OptionIf Transpose is not showing in Excel, copy the source cells first, then select a single empty destination cell and open Home…
- Excel Not Allowing Transpose? Fix Paste and Formula IssuesIf Excel is not allowing Transpose, copy a normal cell range first, then use Home > Paste > Transpose; if that option…
- Excel OFFSET Function: Fix Input and Output ProblemsYes—Excel’s OFFSET function can return a cell or range relative to a starting reference: specify the reference, how many rows and columns…
- Excel Not Showing Average? Fix the Formula and DisplayIf Excel is not showing an average, first check whether you want the result in a worksheet cell or on the status…
- Dollar Signs Not Lining Up in Excel? Fix the FormatIf dollar signs are not lining up in Excel, select the cells and choose Home > Number > Accounting Number Format to…
- Columns Not Showing in Excel? Fix Hidden or Missing ColumnsIf columns are not showing in Excel, select the column headers on both sides of the gap, right-click, and choose Unhide. If…
- Circular Reference in Excel: How to Find and Fix ItTo get rid of a circular reference in Excel, edit the formula so it no longer refers to its own cell, either…
- Excel Circular Reference Keeps Popping Up? Fix ItIf Excel keeps showing a circular reference warning, a formula is referring to its own cell either directly or through a chain…
- Data Analysis in Excel Not Showing? Fix the ToolPakIf Data Analysis is missing from Excel’s Data tab, enable the Analysis ToolPak: in Excel for Microsoft 365 on Windows, select File…
- Excel Solver Not Converging? Fix the ModelIf Excel Solver is not converging, first check that the selected solving method matches your model, then verify the starting values, formulas,…
- Excel Lost Conditional Formatting? Find and Fix ItExcel conditional formatting usually has not disappeared completely: the rule may apply to a different range, be hidden by a higher-priority rule,…
- Clean an Excel Table: Fix Messy DataTo clean an Excel table, first make a copy of the workbook, convert the data range to a table with Insert >…
- Clean Excel Formatting: Remove Clutter and Fix StylesTo remove formatting in Excel for Microsoft 365 on Windows, select the cells, then choose Home > Clear > Clear Formats. This…
- Excel SUM Total: How to Add Cells and Fix ErrorsTo calculate a total in Excel, use the SUM function: with amounts in B2:B10, enter =SUM(B2:B10) in an empty cell. If B2,…
- Excel Sum Not Adding Correctly? Diagnose and Fix ItIf an Excel sum is wrong, first check that the formula covers the intended cells, the entries are real numbers rather than…
- Excel SUM Ignore #N/A Errors: Practical Fixes and FormulasYes. In Microsoft Excel for Microsoft 365, if the values to total are in B2:B10, use =SUM(IFNA(B2:B10,0)) to treat #N/A entries as…
- Excel MAX Ignore #N/A: Two Reliable FormulasTo make Excel’s MAX ignore errors such as #N/A, use AGGREGATE with function number 4 and option 6. For a range in…
- Excel MAX: Ignore #DIV/0! ErrorsYes. With values in A2:A10, use =AGGREGATE(4,6,A2:A10) to return the largest numeric value while ignoring #DIV/0! and other error values in that…
- Large Excel File Keeps Crashing? Practical Fixes to TryIf a large Excel file keeps crashing, first make a copy of it, then open Excel in Safe Mode and try the…
- Excel Arrow Keys Not Moving Cells? Fix ItIf Excel’s arrow keys are scrolling the worksheet instead of moving the active cell, turn off Scroll Lock: press the Scroll Lock…
- 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:…