How-to: Make a drop-down list in Excel

If you're wanting data validation in spreadsheet forms and template documents, a drop-down list remains the most common way to achieve it. Skipping over the question why am I covering a Microsoft product when there's a perfectly good LibreOffice alternative, let me just say; 'because someone asked me.'