You can do this too
Download "The one essential add-in for all Excel users."
“Working in Excel will be fun again with all these extra supersmart tools”
ASAP Utilities, description of our Excel tools
English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語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 utility
In the Excel menu choose: ASAP Utilities » Information » Find bad cell references (#REF!)« Return to the list of “Information” tools.
| « Previous Count number of sheets | Next » Find too narrow columns (####) |
You can do this too
Download "The one essential add-in for all Excel users." Download
Additional keywords for this tool:
#REF! error occurs when a cell reference is not valid, bad, incorrect, bad
#REF! error occurs when a cell reference is not valid, bad, incorrect, bad
© 1999-2020 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands
Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
