Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Excel / March 2008



Tip: Looking for answers? Try searching our database.

Turn off green indicators

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John Holt - 29 Mar 2008 03:20 GMT
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 - 29 Mar 2008 14:16 GMT
> 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. - 29 Mar 2008 23:39 GMT
On 3/29/08 6:16 AM, in article
jemcgimpsey-978D26.07164129032008@news.microsoft.com, "JE McGimpsey"
<jemcgimpsey@mvps.org> wrote:

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

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 - 31 Mar 2008 13:33 GMT
On 3/29/08 6:39 PM, in article
C4141346.67D4%nnager@vnoxsxpxaxmv.fullerton.edu, "Norman R. Nager, Ph.D."
<nnager@vnoxsxpxaxmv.fullerton.edu> wrote:

> On 3/29/08 6:16 AM, in article
> jemcgimpsey-978D26.07164129032008@news.microsoft.com, "JE McGimpsey"
[quoted text clipped - 21 lines]
>
> 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.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.