Open Microsoft Excel on your desktop and create a blank workbook. Lets open the existing Excel workbook. Create a new sheet from the bottom menu. Open your Excel sheet and fill in a description of ...

To create a drop-down list in Excel, follow these steps-Select a cell where you want to show the drop-down menu. Go to Data > Data Validation. Select the List from the Allow menu.