Ignore error

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
 
L

Luke M

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.
 
M

Michelle

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
 
H

Howard Brazee

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.

That's why I didn't find it!
P.S. In Excel Options you can reset any ignored areas if you need to.

I probably will do this.

--
"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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sending a macro-enabled spreadsheet 2
Programming question 5
Lost horizontal scroll bar 0
Months between two dates 5
VB macros in new Excel 24
Copying a row to another spreadsheet 1
Names 5
Help in determining age 9

Top