How to add drop down list in MS Excel

What is Microsoft Excel?

Excel is a Software program provided by Microsoft, which is one of the leading companies in the field of IT. Excel is initially released in 1987 for windows and 1985 on macOS and Developed by Microsoft. Excel is made up of numerous spreadsheets that help you to contain or store large no. Of data on a collective level. Excel helps their users to make a better comparison between the Several Variables to accurate analysis of the Subjects.

So, if you guys are here then, you may want to know how we can add drop down in excel. So, Today we will teach you about “How to add drop down in Excel” in a meaningful manner.

Noteworthy

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

How to add a drop down in Color?

While To add drop down in Color, you should all the essential vital functions of Excel.
Here are the steps to perform the above-written Subject as –

1. First, click on start and All program and then open Microsoft Excel.
2. Then, create a list in a hidden column, and after it, 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 dropdown list and select “Data Tab and then Select Data Validation. Choose “List in allow Section.”
4. Click on Source box and select the cells in which list you created and click OK.
5. Select the dropdown list and click on the Home tab—conditional formatting in styles group.
6. Point Highlight cell rules and select more rules. (new dialogue box opens)
7. Select “Format Only Cells That Contain” from the Select a Rule Type list. And Select “Specific Text.” Then, Insert the first list item in the third box and click the “Format” button.
8. Then, select the “fill tab” and choose the Color and click OK to apply.

How do I add a dropdown list from another sheet?

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

1. Open the book in which you want to create a dropdown list.
2. Click on the Menu bar—Insert—name—Define.
3. Type a name for the record.
4. In refers to box, type = and workbook name, Exclamation mark, and the range name.
5. Then, click on, OK.
   Next, you have to create a dropdown list that can be created by the above steps.
6. How to add a dropdown list for the entire Column?

All the steps are the same for creating a dropdown for the entire Column, but In this, you have to “select the Cell range for the entire column.”

How to add Calendar dropdown in Excel?

>
1. Open your 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 Developer tab—control groups—Insert—More control button.
5. Select the MS date and time picker and click OK.
6. After it, click on a cell on which you want to add later, go-to design tab—control groups, and turn off design Mode to “activate the dropdown calendar.”

How to add Yes/No dropdown in Excel?

1. Open your Microsoft Excel.
2. Select the list where you want to put the Yes/No option.
3. Click Data—Data Validation.
4. ideationiideation selection allows a dropdown list and types yes/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 drop down in Excel by following the given steps carefully.

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

Hopefully, We assume that this article remains informative for you, and You have successfully known about “How to add dropdown list in Excel.” Thanks for being with us, share your more valuable feedback and opinion If any query let us know in the comment section down below.