Here's something annoying about Excel 2011 on the Mac. The autocomplete feature offers the choices in a drop-down menu like this: To select the entry I have to arrow down then press Enter. Excel 2007 on Windows and Libre Office on the Mac does it this way: To select the entry you only have to hit Enter or Tab out of the cell. This latter way of doing it works much better. I've searched all through the Preferences for Excel 2011 and can't find anything where I can make it work the way I want. Is there a way?