Click the "OK" button to create the drop-down list for the selected cell or group of cells on the worksheet, or "Sheet2." Save the workbook. Hover over a cell to reveal the drop-down list box.

Select a cell where you want to create a drop-down list. You can also select a group of cells, an entire column, or a row. Navigate to Sheets menu and click on the option Data.