Entering Data Using Pick From Drop Down List

Besides using AutoComplete feature, we can also display a list of previously entered text in the cells that are actively using the Pick From Drop Dwon List. According to the authors, this method is relatively easy because all the data displayed (not just the text that have the same initial letter).

1. Create a new workbook (press Ctrl + N) and create data in the range A1: A3

2. Place the cell pointer padaq A4. Click the right mouse button then select Pick From Drop Down List.

 
3. In cell A4 and then display a list of text that has been entered previously.

 
4. Select the data to be entered using the mouse or keyboard and then press Enter.

Here's my explanation of how sedikt Entering Data Using Pick From Drop Down List may be useful for you all.