Turn off green indicators

[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

 

[JE McGimpsey]

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

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

 

[Norman R. Nager, Ph.D.]

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

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

 

[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

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