Autocomplete Text

**kskukalek** · 07-28-2019, 01:25 AM

Hello, Excel on my mac has a feature where when I begin to type a number, if there is a matching beginning to a number, it pulls up a drop-down menu to show previously entered similar numbers. My PC, however, does not give this same function on Excel for windows. I'm a little confused as to how exactly this feature works, how to enable/disable it and why it might not be working on Windows. Any help would be really appreciated. See picture for the drop-down I'm referring to.

Screen Shot 2019-07-28 at 1.16.11 AM.png

**alansidman** · 07-28-2019, 01:44 AM

https://support.office.com/en-ie/art...a-86f8d4f9fe20

**AliGW** · 07-28-2019, 01:47 AM

It doesn't work in the same way in Windows. All you get is an in-cell suggestion, not a drop-down list.

**kskukalek** · 07-28-2019, 01:51 AM

Even when I start to type the number in windows, no type of autocomplete happens. Only with words...

The application here is a purchase log & if I begin to enter an invoice number that’s already been entered, having that list (or any kind of autocomplete) alerts that I’m making a duplicate entry...

**kskukalek** · 07-28-2019, 01:50 AM

That feature is turned on on my PC but does not give the drop-down menu for numbers like my Mac. It will autocomplete a word, but does not function the same as Excel on Mac. Help!

**AliGW** · 07-28-2019, 01:58 AM

That is correct - numbers read from right to left (units, tens, hundreds, etc.), so Excel doesn't know what you are typing until you've finished with a number.

Is this really a feature of the Mac (I have never had one), or does this workbook have some coding that is making this happen? It can be done with coding in Windows.