Using selection lists
Selection lists are available only for text, and are limited to using only text that has already been entered in the same column.
To use a selection list, select a blank cell and press Ctrl+D. A drop-down list appears of any cell in the same column that either has at least one text character or whose format is defined as Text. Click on the entry you require.