25th November 2019


How will you find cells with data validation?

To create a drop-down list and restrict values in the cell to these entries, follow these steps:
  1. Select cell A1.
  2. On the Data menu, click Validation.
  3. On the Settings tab, click List in the Allow drop-down list.
  4. By default, the Ignore blank and In-cell Dropdown check boxes are selected.
  5. In the Source box, type a,b,c.

Correspondingly, where is the drop down list in Excel?

How to add a drop-down list to an Excel cell
  • Create the list in cells A1:A4.
  • Select cell E3.
  • Choose Validation from the Data menu.
  • Choose List from the Allow option's drop-down list.
  • Click the Source control and drag to highlight the cells A1:A4.
  • Make sure the In-Cell Dropdown option is checked.
  • Click OK.

How do I change the contents of a drop down list in Excel?

Edit a drop-down list that's based on a range of cells
  1. Select the worksheet that has the data for your drop-down list.
  2. Do any of the following:
  3. On the worksheet where you applied the drop-down list, select a cell that has the drop-down list.
  4. Go to Data > Data Validation.

How do you create a drop down list in Excel 2016?

  1. In a new worksheet, type the entries you want to appear in your drop-down list.
  2. Select the cell in the worksheet where you want the drop-down list.
  3. Go to the Data tab on the Ribbon, then Data Validation.
  4. On the Settings tab, in the Allow box, click List.
  5. Click in the Source box, then select your list range.
Write Your Answer


100% people found this answer useful, click to cast your vote.

5 / 5 based on 2 votes.


Press Ctrl + D to add this site to your favorites!