On Saturday, June 19, 2004, at 06:30 PM, Don Wakefield wrote:
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.
--
"Wherever you go, there you are." - B. Banzai, Ph.D. Bruce Johnson
-- 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
