Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- 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…
- 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…
- 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…
- 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…
- Standard Error in Excel: How to Calculate ItTo find the standard error of the mean in Excel, divide the sample standard deviation by the square root of the number…
- Why Is Hanging Indent Not Working in Word?A hanging indent in Word usually fails because the wrong paragraph or setting is being changed, or because a list’s indentation is…
- Google Sheets Wrap Text Not Working? How to Fix ItIn Google Sheets, wrap text often seems broken because the cell is set to Overflow or Clip, the row is too short,…
- Why Block Sender Does Not Work in Outlook and How to Fix ItBlock Sender in Outlook usually does not stop a message from being sent or make it disappear; it tells Outlook to treat…
- Unable to Create Rules in Outlook? Find the Right FixIf Outlook won’t let you create a rule, first check that you’re using the right rule settings for your Outlook version and…
- Outlook Share Calendar Button Not Working? How to FixIf Outlook’s Share Calendar button is missing, disabled, or does nothing, first check that you are using a calendar stored in an…
- Outlook Change View Not Working? Fixes That HelpIf Outlook’s Change View command is not working, first check that you are using classic Outlook for Windows: select View > Change…
- Outlook Block Sender Not Working? Fix the ProblemIf Outlook’s Block Sender command is not working, first check that the address is in the blocked list for the account receiving…
- Microsoft Word Hanging Indent Not Working? Fix It FastIf a hanging indent in Microsoft Word is not working, select the affected paragraph and set it explicitly in the Paragraph dialog:…
- Microsoft Outlook Block Sender Not Working? Try These FixesIf Microsoft Outlook’s Block Sender command is not stopping unwanted messages, check that the address is on the blocked list for the…
- Hanging Indent in Word: How to Fix ItTo fix a hanging indent in Microsoft Word, select the affected paragraph, open the Paragraph settings, and set Special to Hanging or…
- How to Fix Mail Merge in Word: Fields, Data, and PrintingTo fix mail merge in Word, check that your recipient list has clear column headers and valid records, reconnect the data source,…
- How to Fix Double Spaces Between Words in Microsoft WordTo fix double spaces in Word, open Home > Replace, enter two spaces in Find what and one space in Replace with,…
- How to Fix Double Spacing in WordTo fix double-spaced lines in Word, select the affected text, then choose Home > Line and Paragraph Spacing > 1.0. If the…