Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- 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…
- Remove Double Spaces in Word and Fix Double Line SpacingTo remove repeated spaces between words in Microsoft Word, open Home > Replace, enter two spaces in Find what and one space…
- Google Sheets: How to Wrap Text in Cells and Fix RowsTo wrap text in Google Sheets in a web browser, select the cell or cells, then choose Format > Wrapping > Wrap.…
- Google Sheets Freeze Rows Not Working? Fix the ViewIf frozen rows in Google Sheets keep scrolling away, open the correct sheet tab and choose View > Freeze > 1 row,…
- Google Sheets Filter Search: Find Data and Fix IssuesTo search data with a filter in Google Sheets, select your data range, choose Data > Create a filter, then open the…
- Google Sheets Filter Not Filtering? Fix the Common CausesIf a Google Sheets filter is not filtering, check that the filter covers the full data range, that you selected the right…
- Google Sheets Filter Range: Extend It and Fix Common IssuesYes—when a Google Sheets filter does not include new rows, the reliable fix is to remove it and create a new filter…
- Undo Wrap Text in Google Sheets and Fix Cell DisplayTo undo text wrapping in Google Sheets, select the wrapped cells and choose Format > Wrapping > Overflow. This turns off wrapping…
- Google Sheets Date Format Not Working? Here’s How to Fix ItIf Google Sheets date formatting is not working, first check whether the cell contains a real date value rather than text; select…
- Google Sheets Checkbox Not Working? Fixes That HelpIf a Google Sheets checkbox is not working, first check that you can edit the cell, then select it and choose Insert…
- Google Sheets Checkbox on Mobile: Add, Use, and FixYes—you can tap existing checkboxes in the Google Sheets app on an iPhone or Android device to mark them checked or unchecked.…
- Fix Date Format in Google Sheets: Dates ExplainedTo fix a date’s appearance in Google Sheets, select the affected cells and choose Format > Number > Date; for a particular…
- Google Sheets Date Format: How to Change and Fix ItTo change a date’s appearance in Google Sheets, select the cell or range and choose Format > Number > Date. For a…
- Outlook Block Sender Not Working? Causes and FixesIf you couldn’t block a sender in Outlook, first make sure you selected an email in the correct mailbox and used that…
- Section Break in Word Won’t Delete? Here’s WhyYes, you can remove a section break in Word: show formatting marks, place the cursor immediately before the break, and press Delete.…
- Can’t Add Page Numbers in Word? Fix the Common CausesYes—you can add page numbers in Word from Insert > Page Number, then choose a position and style. If nothing appears, or…
- Google Sheets Apps Script Not Working? Fixes to TryIf Apps Script is not working in Google Sheets, first check whether the script is attached to the right spreadsheet, then open…
- Add Slide Numbers to PowerPoint Not Working? Try These FixesIf slide numbers are missing in PowerPoint, open Insert > Header & Footer, select the Slide number checkbox on the Slide tab,…
- Outlook Excel Previewer Not Working? Fixes That HelpYes—an Outlook Excel preview that will not load is usually caused by a disabled preview setting, a missing or damaged Office preview…
- Word Mail Merge From Excel: Fix Number FormattingIn Word for Microsoft 365 on Windows, format a merge field with a numeric picture switch—for example, { MERGEFIELD Amount \# "$#,##0.00"…
- Excel Data Model Not Working? Diagnose and Fix the CauseIf Excel’s Data Model is not working, first check that you are using Excel for Microsoft 365 on Windows, that the source…
- Excel Data Model Error: Causes and FixesAn Excel Data Model error usually means Excel cannot create, refresh, or read the workbook’s model, which stores related tables for PivotTables…