logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel 365, 2021, 2019, 2016, 2013, 2010 or 2007 with ASAP Utilities in its menu

Find bad cell references (#REF!)

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

Information  ›  Find bad cell references (#REF!)

This utility selects all cells on your worksheets that have a formula with a bad cell references.
Excel displays the value #REF! in such cells.

Starting this tool

Additional keywords for this tool:
#REF! error occurs when a cell reference is not valid, bad, incorrect, bad
Count number of sheets

Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us