Annoying Excel 2011 won't do inline autocomplete!

[InfoTime]

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?

 

[learnin']

excel 2011 not-auto-and-not-complete

Did you resolve this? It drives me nuts, as well. It is a common feature for accurate and speedy data entry. It does seem like a rather important feature...

 

[InfoTime]

Gave up on looking for a solution. It ridiculous that Microsoft changed that. Libre Office (which is free and compatible) does it the correct way.

 

[OlsenPeterE]

Fully agree. This is really annoying. I did submit a feedback suggestion to the MS Excel guys.

 

[Lixivial]

That looks more like a form of auto-correction than it does auto-completion. I would search Microsoft's knowledge base or "answers" community.

One thread that may be of interest could be this one.

 

[jorgefilemon]

did anyone found an answer to this??

 

[Basilh72]

Annoying Excel 2011 won't do inline autocomplete!

I too am looking for an answer to this issue. Has anyone figured out how to fix this problem with MS Excel?