Ignore error

  • Thread starter Thread starter Howard Brazee
  • Start date Start date
H

Howard Brazee

I have a spreadsheet that consists of multiple years of data that have
some headings and footings between each set of 12 monthly rows.

One column of data has a formula like this:
=X140-T140-U140

Every cell except the January cell has the little "Inconsistent data"
mark. "The formula in this cell differs from the formulas from this
area of the spreadsheet".

Well, duh, I know that, I wrote it. I can go to each cell and tell
it to ignore the error, or I can change the error checking rules.

But I was wondering - can I tell it to ignore that error for the whole
column at once? (In the past, I've gone from cell to cell).

--
"In no part of the constitution is more wisdom to be found,
than in the clause which confides the question of war or peace
to the legislature, and not to the executive department."

- James Madison
 
Select the entire range of cells, and make the active cell one of the ones
with the error. Choose the option to ignore error, and it will be applied to
all cells.

Personally, I don't use the "inconsitent formula in region" error checking
because it more often than not causes useless distractions.
 
You ccan select the whole column, but the error will only show if the
'Active' cell has one of the little green corners, so (with the whole column
selected) tab or press enter until the active (white) cell is on one with a
'corner', then click the error alert (smart-tag) which appears, and... Hey
Presto! all the errors are ignored.

P.S. In Excel Options you can reset any ignored areas if you need to.

Love ya

M
 
Back
Top