Excel Drop-Down Menu Suggestions

[ecoalson]

I'm sure there is an easy answer for this that I just cannot come up with. All of a sudden, I am getting what I assume are suggestions when I start typing in a cell with data validation. (Image below)

Anyone know how to get rid of this?

 

[Fluff]

Hi & welcome to MrExcel.
As far as I know, you cannot change that behaviour.

 

[Logit]

Click EXCEL in upper left hand corner of workbook.
Click Excel Options, lower right.
Click "Enable auto-complete for cell values . There should now be no checkmark in the square before.
Click OK

 

[Fluff]

That does not affect data validation.

 

[ecoalson]

Hi & welcome to MrExcel.
As far as I know, you cannot change that behaviour.

It only started up today. It's been only a few days since I used Excel and I am highly adept at it (VBA, etc.). So it's an entirely new phenomenon for me.

 

[ecoalson]

Click EXCEL in upper left hand corner of workbook.
Click Excel Options, lower right.
Click "Enable auto-complete for cell values . There should now be no checkmark in the square before.
Click OK

That unfortunately does not work. It's so bizarre since it just happened when I opened up Excel today.

 

[Fluff]

Yup, it's a new feature.

 

[ecoalson]

Yup, it's a new feature.

How not handy!

 

[Logit]

Fluff ... thanks for the heads up. I didn't see the "data validation" indicated at the end of the sentence. My mind and eyes don't work as well as they used to.