Ignore error
in [Programming]
|
From: Howard Brazee on 14 May 2010 10:07 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
From: Luke M on 14 May 2010 11:11 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. -- Best Regards, Luke M "Howard Brazee" <howard(a)brazee.net> wrote in message news:4vlqu55d87903unvv3js2uc18spupbfjhm(a)4ax.com... >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
From: Michelle on 14 May 2010 11:38 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 "Howard Brazee" wrote: > 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 > . >
From: Howard Brazee on 14 May 2010 18:29 On Fri, 14 May 2010 08:38:09 -0700, Michelle <Michelle(a)discussions.microsoft.com> wrote: >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
|
Pages: 1 Prev: Search and display based on cell value Next: Macro to control Print area/view |