Turn off green indicators

J

John Holt

I have little green indicators on the top left of every cell that are the
sum of other cells that some may not have a value.
How do I disable this feature

Thank you

John
 
J

JE McGimpsey

John Holt <[email protected]> said:
I have little green indicators on the top left of every cell that are the
sum of other cells that some may not have a value.
How do I disable this feature
Click to expand...

Preferences/Error Checking, uncheck the "Enable background error
checking" checkbox.
 
N

Norman R. Nager, Ph.D.

Preferences/Error Checking, uncheck the "Enable background error
checking" checkbox.
Click to expand...

Is there a way to ONLY disable error checking of selected cells in a
specific spreadsheet?

Or, if not, is there a way to turn off error checking for ONLY the whole of
a specific spreadsheet?

(Background: The spreadsheet in question has monthly entries over the years
in a number of columns and rows. Up to a couple times each year, several
no-longer-active rows are moved to the bottom of the spreadsheet where
they're kept for historic purposes. But such moves cause neighboring cells
and still-active-cells' totals to be marked as errors even when no errors
exist.)

Respectfully, Norm
 
B

Bob Greenblatt

Is there a way to ONLY disable error checking of selected cells in a
specific spreadsheet?

Or, if not, is there a way to turn off error checking for ONLY the whole of
a specific spreadsheet?

(Background: The spreadsheet in question has monthly entries over the years
in a number of columns and rows. Up to a couple times each year, several
no-longer-active rows are moved to the bottom of the spreadsheet where
they're kept for historic purposes. But such moves cause neighboring cells
and still-active-cells' totals to be marked as errors even when no errors
exist.)

Respectfully, Norm
Click to expand...
The error checking parameters are global to excel. You can turn it off for
specific error types, but not for specific cells, or worksheets.
 
Top