We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

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

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

JohnRock gravatar image

updated 2021-05-31 23:55:33 +0200

Alex Kemp 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?


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

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

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


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

Seen: 147 times

Last updated: May 30 '18