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.

How to Use Conditional Statements in Excel. Jazz up your Microsoft Excel workbook by creating conditional statements to visually represent trends within your data.