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

[JohnRock]

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.

[erAck]

If your data is tabular (or you can select a rectangular area encompassing it) you can apply an AutoFilter to a selected cell area and then (per column) from the filter dialog uncheck All and check only #VALUE!