Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Power Query Keep Errors: Find and Inspect Error RowsIn Power Query for Excel on Windows, select the column or columns you want to check, then choose Home > Keep Rows…
- Excel Text Box Disappeared? How to Find and Restore a Missing BoxAn Excel text box that disappears is often still in the workbook: it may be hidden in the Selection Pane, suppressed by…
- Excel Time Format Not Working? Fix It Step by StepIf Excel time formatting is not working, first check whether the cell contains a real time value or text: formatting changes how…
- Excel Table New Row Not Following Formatting? Fix ItIf a new row in an Excel table is not following the formatting, first confirm the row is actually inside the table,…
- Excel Table Banded Rows Not Working? Fix It in ExcelIf banded rows are not showing, select a cell in the table, open Table Design, turn on Banded Rows, and choose a…
- Excel Rows Keep Collapsing? Find and Fix the CauseIf Excel rows keep collapsing or disappearing, first check for an active filter, a collapsed outline group, or rows that have been…
- Excel Column Names Changed to Numbers? How to Fix ItIf Excel’s column headings show numbers instead of letters, the usual cause is R1C1 reference style. In Excel for Microsoft 365 on…
- Excel Column Is a Number Instead of a Letter? Fix ItIf Excel shows column headings as 1, 2, 3 instead of A, B, C, turn off R1C1 reference style. In Excel for…
- Excel Column Height: AutoFit Rows and Fix Wrapped TextExcel does not have a separate column-height setting: columns have width, while rows have height. To make text fit vertically, select the…
- Excel Column Filter Not Showing All Values? Fix ItIf an Excel column filter is not showing all values, first clear filters on the other columns and confirm that the filter…
- Excel Column Filter Not Working? Fixes That HelpIf an Excel column filter is not working, select a cell in the dataset and choose Data > Filter (or press Ctrl+Shift+L…
- Excel Column Filter Dropdown: How to Add, Use, and Fix ItIn Excel for Microsoft 365 on Windows, select a cell in your data and choose Data > Filter to add a dropdown…
- Excel Cell Won’t Change Color? Find the FixIf an Excel cell won’t change color, check whether Conditional Formatting is controlling its fill; a rule can override the color you…
- Excel Cell Word Wrap: How to Turn It On and Fix RowsTo wrap text in Excel, select the cell or cells, then choose Home > Wrap Text. Excel for Microsoft 365 on Windows…
- Excel Cell List Drop-Down: Create and Fix OneTo create an Excel cell list drop-down in Microsoft 365 for Windows, select the cell, choose Data > Data Validation, set Allow…
- Excel Cell Pull-Down Lists: Create, Edit, and Fix ThemTo create an Excel cell pull-down list in Microsoft 365 for Windows, select the cell, choose Data > Data Validation, set Allow…
- Excel Cell Keeps Changing My Number? Here’s the FixIf Excel keeps changing a number, first check whether it changed the stored value or only how the cell displays it. For…
- Excel Cell Green Triangle: What It Means and How to Fix ItA green triangle in the upper-left corner of an Excel cell is an error-checking indicator: Excel has noticed something that might be…
- Excel Cell Drop-Down Options: Create, Edit, and FixTo add Excel cell drop-down options in Microsoft 365 for Windows, select the cell, choose Data > Data Validation, set Allow to…
- Excel Cell Drag Not Working? Fix the Fill HandleIf Excel cell dragging is not working, first check whether the fill handle is enabled: in Windows Excel, go to File >…
- Excel Cell Drop-Down Menu: Create and Fix OneTo add a drop-down menu to an Excel cell in Microsoft 365 for Windows, select the cell, choose Data > Data Validation,…
- Excel Cell Background Color: How to Change and Fix ItTo change an Excel cell background color, select the cell or range, then choose Home > Font > Fill Color and pick…
- Excel Workbook Open but Not Visible? Find and Fix ItIf an Excel workbook is open but not visible, first select it from View > Switch Windows; if it has been hidden,…
- Excel Workbook Keeps Freezing? Troubleshooting GuideIf an Excel workbook keeps freezing, first give it a minute to finish, then save a copy if Excel responds; if the…
- Excel Workbook Links Not Working? Fix the Common CausesIf Excel workbook links are not working, first check whether you mean a formula that pulls data from another workbook or a…
- Excel Workbook Duplicate Styles: How to Find and Fix ThemYes, an Excel workbook can contain duplicate styles: separate style records may specify the same or nearly the same formatting, even when…
- Excel File Not Opening? Fix the Blank Screen in ExcelIf Excel opens to a blank screen, first check whether the workbook window is hidden, then start Excel in Safe Mode to…
- Excel File Open in Another Application Error: FixesIf Excel says a file is open in another application, first close the workbook everywhere it may be in use, including other…
- Excel An Unexpected Error Has Occurred? Causes and FixesIf Excel says “An unexpected error has occurred,” save any recoverable work, close and reopen Excel, and check whether the problem happens…
- Excel Text Hidden Behind the Next Cell? How to Fix ItIf Excel text looks hidden behind the next cell, it is usually still in the original cell: Excel is clipping its display…