Select all cells with errors as Claus directed.

In found dialog use Shift and downarrow to select all "founds"

Close dialog. Founds will remain highlighted.

You can Tab through the found cells and edit each using F2do your
edittingEnter without losing the others.


Gord


On Tue, 5 Aug 2014 16:13:12 +0000 (UTC), "tb"
wrote:

On 8/5/2014 at 10:21:36 AM Claus Busch wrote:

Hi,

Am Tue, 5 Aug 2014 15:13:14 +0000 (UTC) schrieb tb:

Is there a formula that will quickly point out to me which cells of
the main spreadsheet have the "#N/A" in them?

Start = Find & Select = Go to Special = Formulas = Errors
will select all formula cells with errors


Regards
Claus B.

Thanks, Claus.
Is there a quick way to jump from one highlighted "#N/A" cell to the
next one? Otherwise I have to go though the whole big spreadsheet many
times in order to find all the cells that are highlighted...