logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Find bad cell references (#REF!)

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

Information  ›  17. 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

Information  ›  17 Find bad cell references (#REF!)
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