Introduction:

Drop-down lists are very useful data entry tools in Excel, Drop-down lists make it easier and more efficient to enter data into your spreadsheets, Simply click the arrow and select the option. You can add drop-down lists to cells in Excel containing options such as Yes and No or any other custom list of options.

How to Add a Drop-Down List in Excel:

1- For Example, we will enter the list of the age range, Enter the list of age ranges into sequential cells down a column or across a row.

2- Select all the cells containing the drop-down list items and then enter a name for the cell range into the Name box above the grid. We named our cell range age.

3- Select the cell into which you want to add a drop-down list and click the “Data” tab.

4- Then click on Data Validation dialog box displays. On the Settings tab, select “List” from the Allow drop-down list.

 

5- In the source box, specify the range that contains the items (In this example, the range is A13:A17).and unchecks “Ignore blank” checkbox and the open input message tab to add a pop message.

6- You can add a popup message that displays when the cell containing the drop-down list is selected. To do this, click the “Input Message” tab in the Data Validation dialog box. Make sure the “Show input message when the cell is selected” box is checked. Enter a Title and an Input message and then click the “OK” button.

7- When the cell containing the drop-down list is selected, you’ll see a down arrow button to the right of the cell. If you added an input message, it displays below the cell. The down arrow button only displays when the cell is selected.

 

8- Click the down arrow button to drop down the list of options and select one.

It is always our pleasure to help and support you,

whether you are a business user or a home user we are always ready to provide support.

you can leave your comment here or contact us on email: info@andi-tech.com

also, you can have a look on our services at https://andi-tech.com

thanks for your valuable time visiting our site.