Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoComplete list should accept ENTER key as well as TAB
If I type: =C An autocomplete menu featuring functions starting with the letter 'C' will appear. Intuitively, DOWN/UP arrows will navigate this menu. It *would* be intuitive to hit ENTER at that point, as Visual Studio developers are familiar with, and have Excel select the AutoComplete item and insert it into the cell. However, the ENTER keypress simply enters the currently entered text into the cell. Instead, the TAB key is expected for this purpose, a key that is not at all intuitive (nor well documented). Now that I know about the TAB key, it's no longer an issue for me, but I worry about all the other people who find it as difficult to discover as I did. Once the user uses the arrow keys to select an item from the auto complete list, they should have every expectation that ENTER will select from it. If they don't use the arrow keys, then they can simply ignore the autocomplete menu and everything (except for UP/DOWN) will behave as if it's not there. Currently the autocomplete menu appears with the first item selected. This would have to be changed to begin with no item selected, pending the first use of DOWN to select an item. Once selection is in the Autocomplete menu, ESCAPE can defocuse the menu and leave the cell in edit mode. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autocomplete from a list on the worksheet | Excel Worksheet Functions | |||
How can I enter an online list of library books into Excell's Boo. | Setting up and Configuration of Excel | |||
autocomplete from a drop down list | Excel Discussion (Misc queries) | |||
formulating if; then; enter list | Excel Worksheet Functions | |||
formulating if; then; enter list | Excel Worksheet Functions |