Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Cell Won’t Expand to Show All Text? Fix ItIn Excel for Microsoft 365 on Windows, select the cell or cells, choose Home > Wrap Text, then choose Home > Format…
- Excel Cell Won’t Calculate? Fix Formulas That Don’t UpdateIf an Excel cell won’t calculate, first check Formulas > Calculation Options > Automatic, then check that the cell is not formatted…
- Excel Cell Outline Not Showing? Fix the Selection BorderIf an Excel cell outline is not showing, first identify which outline is missing: gridlines, a formatted cell border, or the border…
- Excel Cell Not Showing All Text? Fix ItIf an Excel cell is not showing all its text, first select it and choose Home > Wrap Text; then widen the…
- Excel Cell Movement Locked? Fix Arrow Keys and SelectionIf Excel’s arrow keys scroll the worksheet instead of moving the selected cell, turn off Scroll Lock; on Windows, press the Scroll…
- Excel Cell Highlight Not Visible? How to Fix ItIf an Excel cell highlight is not visible, first check whether you applied a real fill color or are only seeing the…
- Excel Cell Keeps Changing to Date? Stop the Auto-FormatIf an Excel cell keeps changing to a date, format the cell as Text before entering the value, or type an apostrophe…
- Excel Cell Height Not Adjusting? Fix the Common CausesIf an Excel cell’s height is not adjusting, select the affected row or rows and choose Home > Format > AutoFit Row…
- Excel Cell Format Not Changing? Find and Fix the CauseIf an Excel cell format is not changing, first check whether conditional formatting is overriding what you set; then check whether the…
- Excel Cell Borders Not Showing? How to Fix Them in ExcelIf Excel cell borders are not showing, first select the affected cells and apply a visible border from Home > Font >…
- Excel Worksheet Won’t Scroll? Fix the CauseIf an Excel worksheet won’t scroll, first check whether Scroll Lock is on; then check for frozen panes or a disabled scrollbar.…
- Excel Cell Auto Expand: How It Works and How to Fix ItExcel does not normally resize a column or row automatically just because you type more text into a cell. To make content…
- Excel Worksheet Not Scrolling? Fix the Most Likely CausesIf an Excel worksheet will not scroll, first check whether Scroll Lock is on, then look for frozen panes or hidden scroll…
- Excel Worksheet Keeps Crashing? Causes, Checks and FixesIf an Excel worksheet keeps crashing, first find out whether Excel fails with every workbook or only one, then open Excel in…
- Excel Workbook Won’t Scroll? Fix Frozen or Stuck Sheets FastIf an Excel workbook will not scroll, first go to View > Freeze Panes > Unfreeze Panes, then check whether Scroll Lock…
- Excel Workbook Not Scrolling? Fix the Common CausesIf an Excel workbook will not scroll, first check View > Freeze Panes > Unfreeze Panes, then check whether Scroll Lock is…
- Excel Workbook Links Not Updating? Fix the CausesIf Excel workbook links are not updating, check the link in Data > Workbook Links and choose Refresh, then confirm the source…
- Excel Workbook Keeps Crashing? Fixes That Actually HelpIf an Excel workbook keeps crashing, first make a copy of the file, then open Excel in Safe Mode and test whether…
- Excel Workbook Protection: What Is Locked and How to Fix ItIf an Excel workbook is protected, Excel is restricting an action because a worksheet, the workbook structure, or the file itself has…
- Excel Workbook Locked for Editing by Me? How to Fix ItIf Excel says a workbook is locked for editing by you, first check whether it is still open in another Excel window,…
- Excel Workbook Has Stale Values? How to Find and Fix ThemIf an Excel workbook shows stale values, first check Formulas > Calculation Options > Automatic, then press Ctrl+Alt+F9 on Windows to force…
- Excel Workbook Gone? Find and Recover the Missing FileIf an Excel workbook seems gone, first check Excel’s Recent list, search your computer for its filename, and look in the Windows…
- Excel File Won’t Scroll? Causes and Fixes to Try FirstIf an Excel file will not scroll, first press Scroll Lock to turn it off, then check View > Freeze Panes >…
- Excel File Won’t Save? Fix the Cause and Recover WorkIf an Excel file won’t save, first use File > Save As to try saving a copy to a local folder such…
- Excel File Won’t Print? Fix Page Setup and Printer IssuesIf an Excel file won’t print, first choose the correct printer in File > Print, then check the print preview and clear…
- Excel File Keeps Not Responding? Causes and FixesIf Excel says Not Responding, first wait a minute or two if the workbook is large or has just opened, saved, or…
- Excel Online: How to Unhide Columns and Fix IssuesTo unhide columns in Excel Online, select the visible column headers on both sides of the hidden column, right-click the selection, and…
- Excel Text Going Out of Cell? Fix Overflow and WrappingIn Excel, text usually spills into the cell to its right when that cell is empty; if the neighboring cell contains anything,…
- Excel Function Not Showing Result? Fix the FormulaIf an Excel function is not showing a result, first check whether Excel is displaying formulas, treating the entry as text, or…
- COUNTIF Not Counting Correctly? Fix Common Excel IssuesIf COUNTIF is returning the wrong number, first check that the range and criterion refer to the cells and values you intend;…