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


Empowering Excel Users Worldwide for 25 Years