Don,
To 'enhance' it can be done, but is a significant amount of work. In a nutshell:
Go to View - Toolbars - Forms. Click the Combo Box icon (looks like a bar with a drop-down), draw the box on the screen, then right click and go to Format Control. The specifics will vary from there, depending on your design parameters for your input form.
More simply, you can turn off the AutoComplete (the function you're describing), under Tools - Options - Edit tab - uncheck Enable AutoComplete for Cell Values.
I am pulling these specific instructions from Excel 2000 on a Windows machine, but the menus should be the same, or at least quite similar, on whatever version of Excel you are on.
HTH!
Richard
From: Don Wakefield <[EMAIL PROTECTED]> Reply-To: "PowerBooks" <[EMAIL PROTECTED]> To: "PowerBooks" <[EMAIL PROTECTED]> Subject: Excel Help Anyone? (OT) Date: Sat, 19 Jun 2004 18:30:22 -0700 (PDT)
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?
_________________________________________________________________
Watch the online reality show Mixed Messages with a friend and enter to win a trip to NY http://www.msnmessenger-download.click-url.com/go/onm00200497ave/direct/01/
-- 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