To create a drop-down list in Excel, execute the following steps. On the second sheet, type the items you want to appear in the drop-down list. Note: if you don't want users to access the items on Sheet2, you can hide Sheet2. How to Create a Drop Down List in Excel for a Cell or Range Select the cell or range you want to use for a drop-down list, then Choose Data Validation from the Data Tools group on the Data tab Select the Settings tab. The most commonly used method of building scenarios is to use a combination of formulas and drop-down boxes. In the financial model, you create a table of possible scenarios and their inputs and link the scenario names to an input cell drop-down box. The inputs of the model are linked to the scenario table. To create a drop-down list in Excel, execute the following steps. On the second sheet, type the items you want to appear in the drop-down list. Note: if you don't want users to access the items on Sheet2, you can hide Sheet2.
On a new worksheet, type the values that you want to appear in your drop-down list. They should be in a single column or row without any blank cells (for easy to use, it is recommended to sort your values).
Select all of your values, right-click, and then click 'Define Name'
Then it will prompt up a 'New Name' window. Type a name for the values of your drop-down list and then click 'OK'. (No space in the name. )
Select the cells that you want to have drop-down list.
Click Data Validation.
In the settings tab, select 'List' from Allow box
From the source field, type equal sign (=) and immediately followed by the name you defined in step 3.
Click OK to confirm.
How To Create A Dropdown List In Excel For Macs
Apply the Conditional Formatting to color coded the drop-down list values.
How To Create A Dropdown List In Excel For Mac Shortcut
Highlight the cells you want to have drop-down list.
Then click 'Conditional Formatting' --> New Rule.
Select 'format only cells that contain'
Edit your condition in the session called 'Edit the Rule Description'.
Click 'format' button to select your desired color in cell.