Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Formulas Not Calculating? Fix the Common CausesIf Excel formulas are not calculating, first choose Formulas > Calculation Options > Automatic, then press F9 to recalculate. If only one…
- Excel Flash Fill Not Working? Fix the Most Common CausesIf Flash Fill is not working in Excel, enter a clear example beside your source data, select the next cell in that…
- Excel: Find Cells With Circular References and Fix ThemIn Excel for Microsoft 365 on Windows, go to Formulas > Error Checking > Circular References, then select a listed cell to…
- Excel Flash Fill Down: How to Use It and Fix IssuesYes. In Excel for Microsoft 365 on Windows, enter one or two examples in an empty adjacent column, select the next cell…
- Excel Find and Replace: Search, Change, and Fix TextTo find and replace text in Excel for Microsoft 365 on Windows, press Ctrl+H, enter the text to find and its replacement,…
- Excel Find and Replace Not Finding Anything? Fix ItIf Excel Find and Replace is not finding anything, first check the search scope and options: press Ctrl+H, set Within to Sheet…
- Excel Find and Replace: Search, Edit, and Fix DataExcel’s Find and Replace feature searches a worksheet or workbook for text, numbers, or other cell content and can change matching entries…
- Excel File Not Responding: Fix Freezes and CrashesIf an Excel file says Not Responding, first wait a minute or two without clicking repeatedly; a large calculation, refresh, or save…
- Excel File Not Opening? Fix Corruption and Recover DataIf an Excel file will not open and Excel reports corruption, make a copy first, then try File > Open > Browse,…
- Excel File Corruption Fix: Safe Recovery StepsTo fix a corrupted Excel file in Microsoft 365 for Windows, make a copy of it first, then open Excel and choose…
- Excel Formula Not Calculating? Fix the Common CausesIf an Excel formula is not calculating, first check Formulas > Calculation Options > Automatic, then check whether the cell is formatted…
- Excel Shortcut Keys: Enable, Use, and Fix Common IssuesIn Excel for Microsoft 365 on Windows, keyboard shortcut keys are enabled by default; there is no master switch you need to…
- Excel Dropdown Menu from a List: Create and Fix ItTo create an Excel dropdown menu from a list, select the cell or cells, go to Data > Data Validation > Data…
- Excel Dropdown List Not Showing? Fix the ArrowIf an Excel dropdown list is not showing, select the cell and check Data > Data Validation: make sure the rule allows…
- Excel Dropdown List Error? Causes and FixesAn Excel dropdown list error usually comes from a missing or incorrect Data Validation source, a disabled in-cell dropdown, or a value…
- Excel Data Validation Error: Causes, Fixes, and Tips ExplainedAn Excel data validation error means an entry conflicts with a rule set for that cell, such as a permitted list, date…
- Excel Data Table Not Working? Fix the What-If ToolIf an Excel What-If Analysis data table is not working, first check that its output formula and test values are arranged correctly,…
- Excel Data Table Not Working? Fix Blank ResultsIf an Excel what-if Data Table shows blank results, first check that its source formula actually returns a value and that the…
- Excel Consolidate Not Working? Fix Common CausesIf Excel Consolidate is not working, check that you selected a blank destination cell, added every source range in the Consolidate dialog,…
- Excel Circular Reference Error: Find and Fix ItAn Excel circular reference warning means a formula refers to its own cell, either directly or through other formulas. To fix an…
- Excel Print Area: Center It on a Page and Fix LayoutTo center a print area on a page in Excel for Microsoft 365 on Windows, open Page Layout > Margins > Custom…
- Excel Cannot Open the File: How to Fix a Corrupt XLSXYes—Excel may be unable to open an XLSX when its workbook file is damaged, incomplete, or not really an Excel workbook despite…
- Excel Box and Whisker Plot Not Working? Fixes to TryIf an Excel box-and-whisker plot is missing, blank, or arranged incorrectly, first check that you are using a supported Excel version and…
- Excel A4 Print Area: Set It Up and Fix Printing ProblemsTo print an Excel worksheet on A4 paper, choose Page Layout > Size > A4, select the cells you want, then choose…
- Error Bars on an Excel Scatter Plot: A Clear GuideIn Microsoft Excel for Microsoft 365 on Windows, select the scatter chart, then choose Chart Design > Add Chart Element > Error…
- Dropdown List in Excel: Create, Edit, and Fix OneIn Excel for Microsoft 365 on Windows, select the cells for the dropdown, choose Data > Data Validation, set Allow to List,…
- Dropdown List in Excel: Create, Edit, and Fix OneIn Excel for Microsoft 365 on Windows, select the cells for the dropdown, then choose Data > Data Validation > Data Validation.…
- Excel Dropdown Lists: Create, Edit, and Fix ThemTo make a dropdown list in Excel for Microsoft 365 on Windows, select the cells, choose Data > Data Validation, set Allow…
- Excel Data Validation Not Working? Fix Common CausesIf Excel data validation is not working, select the affected cells and check Data > Data Validation: confirm the rule type, criteria,…
- Control Z Not Working in Excel? Fix Undo FastIf Ctrl+Z is not working in Excel, first click a worksheet cell and press Ctrl+Z again; on a Mac, use Command+Z. If…