Are there any Excel masters out there? I surely am NOT
and what should be a simple fix has so far eluded me.
I have an item checklist which has one column which
contains a list of items. The column immediately to
its left is a narrow column which will receive either
a "Y", an "N", or an "NA" (Yes, No, or Not Applicable)
My problem is that at some point in the construction,
a few of these narrow cells (and I do mean only
several) have magically become intuitive in a
disagreeable way. They will accept a "Y", but when an
"N" is typed, those few cells create a drop down menu
which is populated with "NA" and Excel populates the
cell with "NA" even if you only type "N" and "return".
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.
Anybody have any ideas as to how to kill or enhance
Excel's intuition?
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
--
PowerBooks is sponsored by <http://lowendmac.com/> and...
Small Dog Electronics http://www.smalldog.com | Enter To Win A |
-- Canon PowerShot Digital Cameras start at $299 | Free iBook! |
Support Low End Mac <http://lowendmac.com/lists/support.html>
PowerBooks list info: <http://lowendmac.com/lists/powerbooks.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/powerbooks%40mail.maclaunch.com/>
Using a Mac? Free email & more at Applelinks! http://www.applelinks.com
