How to Add a Drop-Down List in MS Excel

Excel is a software program provided by Microsoft, which is one of the leading companies in the field of IT. Excel was initially released in 1987 for Windows and in 1985 for macOS. It was developed by Microsoft. Excel is made up of numerous spreadsheets that help you contain or store large amounts. Of data on a collective level. Excel helps their users make better comparisons between several variables for an accurate analysis of the subjects.

Noteworthy

• Using Excel, you should know all the relevant and essential functions of it.
• Follow every single step given below correctly.
• Use the specific steps for a solution to that particular problem, not any other subject.

How do I add a drop-down in color?

While you add a drop-down in color, you should see all the essential functions of Excel. Here are the steps to perform the above-written subject:

1. First, click on Start and All Programs, and then open Microsoft Excel.
2. Then, create a list in a hidden column, and after that, enter the items in consecutive cells in a single column. (one list item per cell).
3. Select the cells in which you want to add a drop-down list select “Data Tab,” and then select Data Validation. Choose “List in the Allow Section.”
4. Click on the Source box and select the cells in the list you created, then click OK.
5. Select the drop-down list and click on the Home tab—conditional formatting in the styles group.
6. Point Highlight cell rules and select more rules. (A new dialogue box opens.)
7. Select “Format Only Cells That Contain” from the Select a Rule Type list. Select “Specific Text.” Then, insert the first list item in the third box and click the “Format” button.
8. Then, select the “fill tab,” choose the color, and click OK to apply.

How do I add a drop-down list from another sheet?

To add a drop-down from another sheet, first, you have to create a workbook with a master list.

1. Open the book in which you want to create a drop-down list.
2. Click on the Menu bar—Insert—Name—Define.
3. Type a name for the record.
4. In refers to box, type, workbook name, exclamation mark, and range name.
5. Then, click OK.
6. Next, you have to create a drop-down list that can be created by following the above steps.
7. How do I add a drop-down list to the entire column?

All the steps are the same for creating a dropdown for the entire column, but in this case, you have to “select the cell range for the entire column.”

How do I add a calendar dropdown to Excel?

1. Open MS Excel.
2. Click on the Developer tab, and then click on Customise the Ribbon.
3. Then, click on the Developer box and click OK.
4. Open the Developer tab—control groups—Insert—More control button.
5. Select the MS date and time picker, and click OK.
6. After that, click on a cell on which you want to add later, go to the design tab—control groups, and turn off design mode to “activate the dropdown calendar.”

How do I add a Yes/No dropdown to Excel?

1. Open Microsoft Excel.
2. Select the list where you want to put the Yes/No option.
3. Click Data—Data Validation.
4. Ideation selection allows a dropdown list and you type yes or no in the Source box.
5. Then, click on
6. Hence, you have successfully added a Yes/No list to your Excel sheet.

How do I add the date drop-down in Excel?

To add a drop-down to Excel, follow the given steps carefully.

1. Open MS Excel.
2. Click on the Developer tab, and then click on Customise the Ribbon.
3. Then, click on the Developer box and click OK.
4. Open the Developer tab—control group-Insert-More control button.
5. Then, select MS Date Picker and click OK.
6. After that, click on the cell to which you want to add the calendar.
7. Then, go to the design tab—control groups—and turn off design mode to “activate the dropdown calendar.”