Helllo,

I have a spreadsheet (rather a big one) which shows an error (triangle in
the corner of the cell) in all the cells of a single column. I understand
the (apparent) errors and need to 'ignore' them. I know how to do this one
by one, but there are over 700 cells in the column. Is there a way of
selecting all the affected cells & 'ignoring' the errors in one go ?

I dont want to turn off the error checking because the same error could turn
up elsewhere .

Thanks

KK