The information in this article applies to:
SYMPTOMSIn Microsoft Excel, when you are in Data Entry mode, you may not be able to use the "Pick from list" feature. CAUSEWhen Microsoft Excel is in Data Entry mode, you cannot use scroll bars, you can only select certain cells, and many menu commands are unavailable (dimmed). One of the commands that is unavailable is the Pick From List command (to see this command, click the right mouse button in any cell). WORKAROUNDMethod 1: Instead of using the shortcut menu to get the Pick List, you can press the Alt and Down Arrow keys. This will bring up a list of all the unique items in the active column, and you can choose the item you want from this list.Method 2: Turn off Data Entry Mode. There are two ways to turn off Data Entry Mode in Microsoft Excel, and the method you use will depend on the setting of the DataEntryMode property. If the DataEntryMode property is set to xlOn, then you can exit Data Entry Mode by pressing the Escape key. If the DateEntryMode property is set to xlStrict, then you can only exit Data Entry Mode by running another macro that sets the property to xlOff. STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. MORE INFORMATION
The Pick List is part of the new AutoComplete feature of Microsoft Excel
version 7.0. The AutoComplete feature scans the active column for unique
entries, and when you bring up the Pick List, all of the unique entries are
displayed in a list box. Simply clicking on an item in the Pick List will
enter that item in the active cell, saving you from having to retype
something that already has been entered.
Additional query words: picklist gray grey greyed grayed out
Keywords : |
Last Reviewed: October 6, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |