Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Not Responding: How to Fix It and Recover WorkIf Excel says “Not Responding,” first wait a few minutes and avoid clicking repeatedly; it may be busy calculating, opening a large…
- Force Quit Excel When It Is Not Responding on WindowsIf Excel is frozen on Windows, first give it a minute to recover; if it remains unresponsive, press Ctrl+Shift+Esc, select Microsoft Excel…
- Heat Map in Excel for Crash Data: A Practical GuideYes—you can make a heat map in Excel for crash data, but the right method depends on what you mean by heat…
- Excel Formula Not Calculating? Fix It Step by StepIf an Excel formula is not calculating, first check that calculation is set to Automatic: go to Formulas > Calculation Options >…
- Flash Fill Letters in Excel: Extract, Format, and Fix TextIn Excel for Microsoft 365 on Windows, Flash Fill can extract or reformat letters when you show the pattern in a neighboring…
- Excel Won’t Let You Merge Cells in a Table? Here’s WhyExcel does not allow merged cells inside an Excel table. If you need a merged heading, put it in a row outside…
- Excel Won’t Let You Merge Cells? Fix the Common CausesIf Excel won’t let you merge cells, first exit cell-editing mode by pressing Esc, then select one continuous range on a single…
- Excel Won’t Let Me Hyperlink? How to Fix ItIf Excel won’t let you add a hyperlink, first make sure you are not editing a cell, then select one cell and…
- Excel Won’t Group Rows? Fix the Common CausesIf Excel won’t group rows, select the consecutive rows you want to fold, then choose Data > Outline > Group and select…
- Excel Won’t Let Me Group Rows? Causes and FixesIf Excel will not let you group rows, first make sure you are on an unprotected worksheet with only one sheet selected,…
- Excel Won’t Allow Insert Row? Common Causes and FixesYes—Excel may block a row insertion because the sheet is protected, the new row would push cells or objects past the worksheet’s…
- Excel Flash Fill Not Working? Causes, Fixes, and TipsIf Excel Flash Fill is not working, enter a clear example beside the original data, then choose Data > Flash Fill or…
- Excel Web Import CSV: Open, Load, and Fix DataTo import a CSV into Excel for the web, open a workbook and choose Data > Get Data > Text/CSV if that…
- Excel VLOOKUP Formula Not Calculating? Here’s How to Fix ItIf an Excel VLOOKUP formula is not calculating, first check that the cell is not formatted as Text, that calculation is set…
- Excel Print Area Lines: How to View, Show, Hide, and FixTo view Excel print area lines in Microsoft 365 for Windows, open the View tab and choose Page Break Preview; blue lines…
- Excel Table Heat Maps: Create, Customize, and Fix ThemAn Excel table heat map uses Conditional Formatting to color cells according to their values, making high, low, and middle results easier…
- Excel SUM Formula Not Working? Fix Common CausesIf an Excel SUM formula is not calculating correctly, check that the formula references the intended cells, the values are real numbers,…
- Excel Stuck on Not Responding? Causes, Fixes, and RecoveryIf Excel is stuck on Not Responding, first give it a few minutes if it may be calculating, refreshing data, or opening…
- Excel Formula Not Calculating? Fix the Common CausesIf an Excel formula is not calculating, first check Formulas > Calculation Options > Automatic, then make sure the cell contains a…
- Excel Slicer Reset: Clear Filters and Fix Common IssuesTo reset an Excel slicer in Microsoft 365 for Windows, click the slicer and choose its Clear Filter button—the small funnel with…
- Excel Slicer Report Connections Not Showing? How to FixIf Excel’s Report Connections list is missing or does not show the PivotTable you want, first confirm you selected a PivotTable slicer—not…
- Excel Slicer Only Allows One Selection? Here’s How to FixNo—an Excel slicer can filter for more than one item at a time. In Excel for Microsoft 365 on Windows, click the…
- Excel Scatter Plot: Select Data, Edit Series, and Fix AxesIn Excel for Microsoft 365 on Windows, select the columns containing your X and Y values, then choose Insert > Insert Scatter…
- Excel Scatter Plot Not Plotting X Values? Here’s How to FixIf an Excel scatter plot is not plotting your x values, first confirm that the chart type is XY (Scatter), then check…
- Excel Scatter Plot Gridlines: Add, Format, and FixTo add a grid to an Excel scatter plot, select the chart, then choose Chart Design > Add Chart Element > Gridlines…
- Excel Running Background Query Not Responding? Fix ItIf Excel says a background query is running and stops responding, first give the refresh a little time and check whether it…
- Excel Repair Not Responding? Fix the Hang and RecoverIf Excel’s repair process is not responding, first give it time to finish, especially if the workbook is large; repeatedly clicking or…
- Excel Protected Sheet Not Sorting? How to Fix ItIf Excel will not sort a protected sheet, the usual fix is to unprotect the sheet, unlock the cells in the range…
- Excel Program Not Responding? How to Fix ItIf Excel says “Not Responding,” first give it a minute if a calculation, refresh, or large file operation may be underway; repeatedly…
- Excel Print Area Won’t Clear? Fix the Stuck SettingIf an Excel print area won’t clear, select the affected worksheet and choose Page Layout > Print Area > Clear Print Area.…