Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Not Doing Formulas? Fix Calculation and Cell IssuesIf Excel is not doing formulas, first check Formulas > Calculation Options > Automatic, then make sure the formula cell is not…
- Excel Not Dragging Formula? Fix Fill Handle IssuesIf Excel will not drag a formula, enable the fill handle in File > Options > Advanced, then drag the small square…
- Excel Not Displaying Formula Results? Find the FixIf Excel is showing formulas instead of their results, turn off Formulas > Formula Auditing > Show Formulas or press Ctrl+` on…
- Excel Not Displaying Sum? Fix the Status Bar and FormulasIf Excel is not displaying a sum, first select the numeric cells: Excel for Microsoft 365 on Windows normally shows their total…
- Excel Not Deleting All Selected Cells? How to Fix ItIf Excel is not deleting all the selected cells, first check whether you pressed Delete to clear their contents or used Home…
- Excel Not Allowing Insert Row? How to Fix ItIf Excel won’t let you insert a row, first check whether the sheet is protected, then check whether Excel thinks the worksheet’s…
- Excel Not Adding Numbers? Fix Text, Formulas, and TotalsIf Excel is not adding numbers, first check whether the entries are stored as text; the SUM function ignores text in a…
- Excel Crashing? Causes, Fixes, and Recovery StepsIf Excel keeps crashing, first reopen it and save any recovered work to a new file; then restart Windows and test Excel…
- IFERROR with XLOOKUP in Excel: Handle Missing ResultsYes—use IFERROR around XLOOKUP when you want to replace an error with a message or another value. With the requested code in…
- IFERROR Excel: Show Blank Instead of an ErrorYes. In Excel for Microsoft 365, use IFERROR with an empty text string as its second argument to display a blank when…
- VLOOKUP Excel Troubleshooting: Fix Common Formula ErrorsTo troubleshoot VLOOKUP in Excel, check that the lookup value is in the first column of the selected range, use FALSE for…
- Python pandas Excel Import: Read Files and Fix ErrorsTo import an Excel workbook with pandas, use pd.read_excel(): df = pd.read_excel('sales.xlsx', sheet_name='January'). Install pandas and a compatible Excel-reading engine first; for…
- Excel Text Not Staying in Cell? Fix the OverflowIf text looks as though it is spilling out of an Excel cell, it usually has not moved: Excel is displaying the…
- Excel Text Extending Beyond Cell: How to Fix ItIn Excel, text can extend visually beyond a cell when the cells beside it are empty; the text still belongs only to…
- Excel Date Input: Enter and Fix Dates That Won’t ParseIn Excel for Microsoft 365 on Windows, enter a date in a format your regional settings recognize, such as 11/2/2026, then press…
- Excel Date Not Recognized? How to Fix Dates Stored as TextIf Excel does not recognize a date, the cell often contains text that merely looks like a date, or the date was…
- Excel Table Showing Formula Not Result? Fix ItIf an Excel table is showing a formula instead of its result, first turn off Formulas > Formula Auditing > Show Formulas,…
- Excel Table Not Expanding? Fix the Auto-Expand SettingIf an Excel table is not expanding when you enter data beside it, first check the AutoFormat As You Type setting: in…
- Excel Table Design Tab Missing? How to Find It AgainIf the Excel Table Design tab is missing, click a cell inside the table: the tab is contextual and appears only when…
- Excel Table Colours: Change, Customize, and Fix ThemExcel table colours come from the table’s style: select a cell in the table, open Table Design, and choose a design in…
- Excel Table Auto Expand: How It Works and How to Fix ItYes. In Excel for Microsoft 365 on Windows, a table usually expands automatically when you type or paste data directly next to…
- Excel Row Won’t Expand? Fix Height and Hidden RowsIf an Excel row won’t expand, select it and choose Home > Format > AutoFit Row Height, or drag the lower border…
- Excel Row Numbers Missing? Causes and How to Restore Them in ExcelIf Excel’s row numbers have disappeared, first turn row headings back on: in Excel for Microsoft 365 on Windows, select View and…
- Excel Row Numbers Blue? Why It Happens and How to FixBlue row numbers in Excel usually mean that a filter is active on the worksheet, so some rows are hidden from view.…
- Excel Column Not Sorting With Other Columns? Fix ItIf an Excel column sorts without its neighboring columns, Excel is sorting only the selected cells instead of the complete records. Undo…
- Excel Column Locked When Scrolling? Fix Freeze PanesTo keep an Excel column visible while you scroll horizontally, choose View > Freeze Panes > Freeze First Column. To hold a…
- Excel Column Headers Changed to Numbers? How to Fix ItIf Excel’s column headings show numbers instead of letters, the R1C1 reference style is turned on. In Microsoft 365 for Windows, go…
- Excel Column Autofit: Fit Widths and Fix ProblemsTo autofit a column in Excel for Microsoft 365 on Windows, select the column or columns, then choose Home > Format >…
- Excel Column and Row Labels Missing? Restore Them FastIf Excel’s column letters and row numbers are missing, turn on Headings: on Windows, open the View tab and select Headings in…
- Excel Column A Missing? How to Bring It BackIf column A is missing in Excel, it is usually hidden, scrolled out of view, or reduced to zero width—not deleted. To…