Ask Your Question
2

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

asked 2018-05-30 16:35:28 +0100

JohnRock gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2018-06-01 14:23:01.933390

1 Answer

Sort by » oldest newest most voted
3

answered 2018-05-30 17:31:15 +0100

erAck gravatar image

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!

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2018-05-30 16:35:28 +0100

Seen: 37 times

Last updated: May 30