Today there was a requirement for adding a dropdown list in one Excel document. A Google search gave me the following link that solved my problem. I realised that there is a lot to learn in Excel.
Create a drop-down list from a range of cells – Excel – Microsoft Office Online