Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Calc: how do I go through all #VALUE! cells?

I have a huge sheet with many formulas. Some value cells have bad data in them and need to be changed. All formulas associated with those cells appear as "#VALUE!". It would take ages to find all such cells manually. Entering "#VALUE!" in "Find" doesn't work. What do I do?

Thanks.