Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Average Function in Excel Not Working? Fix the CauseIf Excel’s AVERAGE function is not working, first check that the range contains numbers Excel recognizes and that the formula points to…
- Excel Table Not Auto Filling Formula? Fix ItIf an Excel table is not auto filling a formula, first check that the range is a real Excel table and that…
- Excel Date Format Won’t Change? Causes and Fixes GuideIf Excel date format won’t change, the cell may contain text instead of a real date, or a conditional format or protection…
- Excel Not Working After an Update? Causes and FixesIf Excel started crashing, freezing, displaying errors, or behaving differently after an update, first restart Windows and Excel, then check whether the…
- Excel Can’t Push Non-Empty Cells: How to Fix ItExcel shows this error when inserting cells, rows, or columns would force existing worksheet content beyond the sheet’s last available row or…
- How to Change a Range Name in Excel and Fix ReferencesTo change a named range in Excel for Microsoft 365 on Windows, open Formulas > Name Manager, select the name, choose Edit,…
- Excel SUM Formula Not Working? How to Fix ItIf Excel’s SUM formula is not working, check that the formula begins with an equals sign, its range includes the intended cells,…
- Excel Date: How to Change, Format, and Fix Date ValuesTo change a date in Excel, select the cell and type the correct date; to change only how it looks, select the…
- Excel CONCAT Formula Not Working? Common Fixes and ChecksWith a first name in A2 and a surname in B2, enter =CONCAT(A2," ",B2) to join them with a space. If the…
- LEFT Excel Formula Not Working? Fix ItIf your LEFT formula is not working, check that the formula starts with an equals sign, refers to the cell you intend,…
- Excel Not Working After Update? Fixes That Usually HelpIf Excel stopped opening, freezes, or behaves differently after an update, first restart Windows and check whether the problem affects every workbook…
- Spreadsheet Print Area: Set, Preview, and Fix PrintingA spreadsheet print area is the range of cells Excel is instructed to print; set it by selecting the cells, then choosing…
- How to Normalize Dates in Excel and Fix Inconsistent FormatsTo normalize dates in Excel, first convert any text dates into real Excel date values, then apply one consistent number format to…
- Hanging Indent in Word: Set It Up and Fix Common IssuesTo give text a hanging indent in Microsoft Word, select the paragraph or paragraphs, open the Paragraph settings from the Home tab,…
- Freeze VLOOKUP Formula in Excel: Lock or Fix ResultsTo keep a VLOOKUP’s lookup range from shifting when you copy the formula, make that range absolute by adding dollar signs, such…
- How to Fix Zoom Level in ExcelTo fix the zoom level in Excel for Microsoft 365 on Windows, select the worksheet, click the zoom percentage at the bottom-right…
- Date Format in Excel: How to Fix It (Step by Step)To fix a date that displays incorrectly in Excel for Microsoft 365 on Windows, select the date cells, press Ctrl+1, choose a…
- How to Fix Wrap Text in Excel: Quick Steps and TipsTo fix Wrap Text in Excel, select the affected cells, then choose Home > Wrap Text. If the words still look cut…
- How to Fix Zoom in Excel and Restore a Readable ViewTo fix zoom in Excel for Microsoft 365 on Windows, open the View tab and choose Zoom to set a percentage, or…
- Fix Strikethrough in Excel: Remove or Apply ItTo fix strikethrough in Excel for Microsoft 365 on Windows, select the affected cell or text and press Ctrl+5 to toggle strikethrough…
- How to Fix a SUM Error in ExcelTo fix a SUM error in Excel, first check that the formula points to the right cells, then make sure the values…
- Excel Print Area: How to Fix It and Print the Right CellsTo fix an Excel print area, select the cells you want on paper, then choose Page Layout > Print Area > Set…
- Fix Data Validation in Excel: Lists, Rules, and ErrorsTo fix data validation in Excel, select an affected cell, choose Data > Data Validation, check the Settings tab, and correct the…
- Excel Divide by Zero Error: Causes and Practical FixesTo fix a #DIV/0! error in Excel, check that the formula’s divisor is not zero or blank, then correct the input or…
- How to Fix Borders in Excel: Quick, Reliable StepsTo fix a border in Excel, select the affected cell or range, go to Home > Borders, and choose the edge or…
- Fix Conditional Formatting in Excel: A Practical GuideTo fix conditional formatting in Excel, open Home > Conditional Formatting > Manage Rules, show the rules for the affected cells, and…
- How to Fix an Array in Excel and Repair Formula ErrorsTo fix an array in Excel, identify whether it is a modern spilled formula or a legacy Ctrl+Shift+Enter formula, then edit the…
- Fix a Broken Workbook Link in ExcelTo fix a broken workbook link in Excel for Microsoft 365 on Windows, open the workbook that contains the link, go to…
- Circular References in Excel: How to Find and Fix ThemTo find a circular reference in Excel for Microsoft 365 on Windows, select Formulas > Error Checking > Circular References, then click…
- Uncertainty in Excel: Standard Error and ConfidenceTo estimate uncertainty from repeated measurements in Excel, calculate the mean with =AVERAGE(A2:A6), the sample standard deviation with =STDEV.S(A2:A6), and the standard…