About 400 results
Open links in new tab
  1. How to correct a ##### error - Microsoft Support

    Microsoft Excel might show ##### in cells when a column isn’t wide enough to show all of the cell contents. Formulas that return dates and times as negative values can also show as #####.

  2. Detect formula errors in Excel - Microsoft Support

    Formulas can sometimes result in error values in addition to returning unintended results. The following are some tools that you can use to find and investigate the causes of these errors and determine …

  3. How to correct a #VALUE! error - Microsoft Support

    #VALUE is Excel's way of saying, "There's something wrong with the way your formula is typed. Or, there's something wrong with the cells you are referencing." The error is very general, and it can be …

  4. IFERROR function - Microsoft Support

    How to use the IFERROR function in Excel to trap and handle errors in a formula.

  5. How to avoid broken formulas in Excel - Microsoft Support

    Formulas can sometimes result in error values in addition to returning unintended results. Learn about best practices to avoid those problems.

  6. Repair a corrupted workbook - Microsoft Support

    Recover a corrupted workbook manually when Excel can't start File Recovery mode automatically and learn about saving backup and recovery files to prevent losing your work.

  7. How to correct a #CALC! error - Microsoft Support

    Custom functions that refer to more than 10,000 cells cannot be calculated in Excel for the web, and will produce this #CALC! error instead. To fix, open the file in a desktop version of Excel.

  8. Use error checking to detect errors in formulas

    Here’s how: Click Open in Excel and use error checking to detect errors in formulas. For news about the latest Excel Online updates, visit the Microsoft Excel blog. For the full suite of Office applications and …

  9. How to correct a #SPILL! error - Microsoft Support

    How to correct a #SPILL error in Excel (when a formula returns multiple results and cannot return them to the grid).

  10. How to correct a #REF! error - Microsoft Support

    The #REF! error shows when a formula refers to a cell that's not valid. This happens most often when cells that were referenced by formulas get deleted, or pasted over.