Create an Independent Dropdown . The first Excel dropdown will be independent, meaning it does not rely on another for its options. Under the Department header in column A, select the range of ...

Type P in the required field and select the required option in the drop-down. ... To create a checklist box in Excel, go to the Insert tab and click on the Checkbox option.