Do you want to repeat data that’s already been used in the column?
To enter Yellow in a new cell in the column Excel will bring it up anyway when simply typing Y – this is because there is only one data entry starting with the letter Y.
Conversely if you need to enter Blueish, you will need to enter Bluei to get Excel to show you the correct auto-complete (as we have Blue in our list too). Alternatively, select the next empty cell where you want to insert the data, and press the Alt+Down Arrow keys on your keyboard together.
This will show an instant drop down list of all the unique values. Just select the option you want.