How to make the drop list disappear

[yichuansancun]

Hello -

I have a table for which I didn't use data validation to create any drop down list. However, when I point to any cell in this table, and hit alt + down arrow, it will have a drop down list.

Why is that? And how can I make the list disappear?

Thanks,
Perri

 

[GlennUK]

That's a useful feature of Excel ... to show entries already used in the column.

What would you like to happen when Alt+DownArrow is pressed?

 

[yichuansancun]

Got it... right now, the cell is not a drop down so nothing need to be happen when alt+ arrow down is pressed.

Thanks,
Perri