> Subject: Re: [PCI] Excel Help Anyone? (OT) > From: Bruce Johnson <[EMAIL PROTECTED]>
>> I would like to either loose this intuitive ability >> altogether, or enhance it so that each item had a >> selection which included both "N" and "NA" (in that >> order) so a choice could be made from the list's >> natural state of "Y". Copying cells which act one way >> into cells which act the other has not been >> effective.I don't know what turned this on in these >> few cells. I don't know how to improve it to become >> useful, and I can't find a way to turn it off. > > I don't have Excel here, just at work, so I cannot answer definitively, > but I'm 90% certain this is in the autocorrect/autocomplete settings. > Under Options> Settings, or Options > Tools, I forget which. It *may* > also be settable via command-clicking on the column head. I've run into > this problem before at the College and I know I turned it off somehow. > Bruce Johnson oops! sounds like I was wrong about it being about formulae... a setting sounds a promising avenue... David Elmo -- PCI-PowerMacs is sponsored by <http://lowendmac.com/> and... Small Dog Electronics http://www.smalldog.com | Refurbished Drives | -- Sonnet & PowerLogix Upgrades - start at $169 | & CDRWs on Sale! | Support Low End Mac <http://lowendmac.com/lists/support.html> PCI-PowerMacs list info: <http://lowendmac.com/lists/pci-powermacs.shtml> --> AOL users, remove "mailto:"; Send list messages to: <mailto:[EMAIL PROTECTED]> To unsubscribe, email: <mailto:[EMAIL PROTECTED]> For digest mode, email: <mailto:[EMAIL PROTECTED]> Subscription questions: <mailto:[EMAIL PROTECTED]> Archive:<http://www.mail-archive.com/pci-powermacs%40mail.maclaunch.com/> Using a Mac? Free email & more at Applelinks! http://www.applelinks.com
