Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Keeps Pasting Text to Columns? Fix the SettingIf Excel keeps splitting pasted text across columns, the usual cause is tab characters in the copied text: Excel treats tabs as…
- Excel Keeps Not Responding? Causes and Fixes to TryIf Excel keeps not responding, first give it a minute if it may be calculating or loading data; then check whether the…
- Excel Keeps Doing Text to Columns? Causes and FixesExcel does not normally rerun Text to Columns on its own. If data keeps splitting, a CSV or text import, pasted tabs…
- Excel Showing Formulas Instead of Results? Fix ItIf Excel shows formulas in cells instead of their calculated results, first turn off Formulas > Show Formulas. If only certain cells…
- Excel Insert Row Greyed Out? Causes and How to Fix ItIf Excel’s Insert Row command is greyed out, the usual causes are worksheet protection, read-only access, or a selection that does not…
- Excel Insert Row Ruins My Formulas? Fix the ReferencesUsually, inserting a row in Excel does not ruin formulas: Excel adjusts references when you insert a worksheet row, and formulas that…
- Excel Import CSV with Decimal Point: Fix Number ParsingTo import a CSV with decimal points correctly in Excel for Microsoft 365 on Windows, use Data > From Text/CSV instead of…
- Excel Import CSV with Semicolons: Fix the DelimiterTo import a semicolon-delimited CSV in Excel for Microsoft 365 on Windows, choose Data > From Text/CSV, select the file, set Delimiter…
- Excel Formula Not Calculating? Fix It Without ErrorsIf an Excel formula is not calculating and shows no error, first check whether Excel is set to Automatic calculation, whether the…
- Excel Formula Not Calculating? Fix Zero ResultsIf an Excel formula shows zero, first check Formulas > Calculation Options > Automatic, then confirm the formula points to the cells…
- Excel Formula Correct but Not Calculating? How to Fix ItIf an Excel formula looks correct but does not update, first check Formulas > Calculation Options and select Automatic. If the cell…
- Excel Formula Not Auto Calculating? How to Fix ItIf an Excel formula is not auto calculating, first check that calculation is set to Automatic: on Windows, go to File >…
- Excel Formula Not Calculating? Fix Text ResultsIf an Excel formula appears in the cell as text instead of producing a result, first check whether the cell is formatted…
- Excel Flash Fill: How to Force It and Fix Common IssuesTo force Flash Fill in Excel for Microsoft 365 on Windows, type one example of the result beside your source data, select…
- Excel Flash Fill Not Recognizing a Pattern? Fix ItIf Excel Flash Fill is not recognizing your pattern, enter one or two clear examples beside the source data, select the next…
- Excel Circular References: How to Find and Fix ThemIn Excel for Microsoft 365 on Windows, go to Formulas > Error Checking > Circular References to see cells involved in a…
- Excel File Keeps Getting Corrupted? Causes and FixesIf an Excel file keeps getting corrupted, first make a copy of it, then try Excel’s built-in repair: in Microsoft 365 for…
- Excel Data Table Not Calculating? Fix the SettingsIf an Excel what-if data table is not calculating, first check Formulas > Calculation Options and choose Automatic; the setting Automatic Except…
- Excel Data Table Input Cell Not Valid? Fix the ErrorThe “input cell reference is not valid” message usually means Excel cannot use the cell you entered as a What-If Analysis data…
- Excel CSV Import Issues: Fix Dates, Delimiters, and ZerosTo fix most Excel CSV import issues, import the file through Data > From Text/CSV instead of double-clicking it. Check the delimiter…
- Excel Not Responding? How to Diagnose and Fix the ProblemIf Excel says Not Responding, first wait briefly if it may be calculating or opening a large file; then try saving with…
- Excel Consolidate: Fix Overlapping Source ReferencesYes. In Excel for Microsoft 365 on Windows, Data > Consolidate can reject a source reference if it overlaps another reference already…
- Excel Consolidate Missing? Find the Tool and FixesIf Excel’s Consolidate command seems to be missing, look on the desktop app’s Data tab, in the Data Tools group; on a…
- Excel Circular References: How They Work and Fix ThemAn Excel circular reference occurs when a formula refers back to its own cell, either directly or through other cells; it is…
- Excel Circular Reference Popup: How to Find and Fix ItThe Excel circular reference popup means a formula, directly or through other cells, depends on its own result. To find the problem,…
- Excel Can’t Edit Named Range? Fix Common Editing ProblemsYes—Excel can edit most named ranges. In Excel for Microsoft 365 on Windows, open Formulas > Name Manager, select the name, choose…
- Excel Can’t Insert Row? Fix the Non-Empty Cells ErrorYes—Excel may refuse to insert a row when shifting cells down would push existing content or formatting past the worksheet’s last row.…
- 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…