Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Unable to Sort Dates in Excel? Fix the Date Sorting ProblemIf Excel will not sort your dates chronologically, the most common cause is that some or all of them are stored as…
- Excel Undo and Redo Not Working? Causes and Fixes GuideIf Undo or Redo is unavailable in Excel, first check the Undo and Redo arrows on the Quick Access Toolbar and try…
- Unable to Filter in Excel? Fix the Most Common CausesIf you are unable to filter in Excel, select the full data range, confirm it has one clear header row, then choose…
- Transpose Error in Excel: Causes and FixesTo switch rows and columns in Excel, copy the source range and choose Home > Paste > Transpose, or enter the TRANSPOSE…
- Excel SUM Formula Not Working? Fix Common CausesIf Excel’s SUM formula is not working, check that the referenced cells contain numbers, that the formula covers the intended range, and…
- Strikethrough in Excel: Add It, Remove It, and Fix ItTo apply strikethrough in Excel for Microsoft 365 on Windows, select the cell or cells and press Ctrl+5; press it again to…
- Save Failed in Excel? Fix It and Recover Your FileIf saving fails in Excel, keep the workbook open and try File > Save As > Browse to save a copy in…
- Repair Microsoft Excel: Fix Office, Files, and ErrorsTo repair the Microsoft Excel program on Windows, close Office apps, then open Settings > Apps > Installed apps, find Microsoft 365…
- Predictive Formula Not Working in Excel? FixesIf a predictive formula is not working in Excel, first check that the inputs are numeric, the known-value ranges are the same…
- Power Query Not Working in Excel? Causes and FixesIf Power Query is not working in Excel, first open Data > Queries & Connections, right-click the affected query, choose Edit, and…
- Pasting Formula in Excel Not Working? Fixes That HelpIf pasting a formula in Excel is not working, first check whether the destination cell is formatted as Text, whether Excel is…
- Password Protect Excel Not Working? Find the Right FixIf Excel password protection is not working, first identify what you protected: encrypt the workbook to require a password to open it,…
- Office 365 Excel Auto Calculation Not Working? FixesIf Excel for Microsoft 365 is not updating formula results, first choose Formulas > Calculation Options > Automatic. If results still do…
- Excel Number Format Box: Find, Use, and Fix FormatsThe Number Format box in Excel is the dropdown on the Home tab that usually displays General; use it to change how…
- Excel File Too Large? How to Find and Fix It in ExcelIf your Excel file is too large to open, save, email, or share, first work out whether the problem is its size…
- Microsoft Excel Repair Tool: Fix Damaged WorkbooksMicrosoft Excel’s built-in repair tool is called Open and Repair. In Excel for Microsoft 365 on Windows, go to File > Open…
- Microsoft Excel: How to Unmerge Cells and Fix LayoutsTo unmerge cells in Excel for Microsoft 365 on Windows, select the merged cell or range, then choose Home > Merge &…
- Microsoft Excel File: How to Open It and Fix ProblemsYes. To open a Microsoft Excel file in Excel for Microsoft 365 on Windows, start Excel, select File > Open > Browse,…
- Microsoft Excel Document Not Saved Error: How to Fix ItIf Microsoft Excel says Document Not Saved, first protect your work: use File > Save As > Browse to save a copy…
- Microsoft Excel Drag Formula Not Working? Fixes That HelpIf dragging a formula in Microsoft Excel does not fill the cells you expect, first check that you are pulling the small…
- List Missing Numbers in Excel With Simple FormulasTo list missing integers in an Excel sequence, use a dynamic-array formula that creates every number between the smallest and largest values,…
- LEN Formula Not Working in Excel? Common FixesIf the LEN formula is not working in Excel, first enter =LEN(A1) in a cell formatted as General and replace A1 with…
- Power Query Key Not Matching Error: Causes and FixesThe Power Query error “The key didn’t match any rows in the table” usually means a query is looking for a sheet,…
- INDEX MATCH Excel Spill Error: Causes and Fixes ExplainedAn INDEX/MATCH formula usually returns one value, so a #SPILL! error means Excel is trying to return results into multiple cells and…
- Excel #VALUE! Error: Causes and FixesIn Excel, #VALUE! means a formula received a value or argument it cannot use, often text where a calculation expects a number.…
- Excel IFERROR: Show a Blank Instead of an ErrorTo make an Excel formula display a blank instead of an error, wrap the calculation in IFERROR and use an empty text…
- How to Undo in Excel When the Undo Option Is MissingIf Excel has no visible Undo option, press Ctrl+Z on Windows or Command+Z on Mac to reverse the most recent undoable action.…
- Undo Deleted Excel Sheet Tabs: Restore a Missing WorksheetTo undo a deleted sheet tab in Excel for Microsoft 365 on Windows, press Ctrl+Z as soon as you can, or select…
- How to Undo in Excel When Ctrl+Z Isn’t WorkingIf Ctrl+Z will not undo your last change in Excel, first click a cell outside any active edit and try the Undo…
- Excel File Won’t Open: How to Repair ItIf an Excel file will not open, first make a copy of it, then use Excel for Microsoft 365 on Windows: choose…