How to add to drop-down list in excel

Create a drop-down list for the cell

To create your own drop-down list for the cell, do the following:

   1.   Create a column or a row of the items in the active spreadsheet for the drop-down list.

   2.   Select the cell that needs a drop-down list for data validation (cell B2, in this example).

How to create a list in excel

   3.   On the Data tab, in the Data Tools group, click Data Validation:

   4.   In the Data Validation dialog box, on the Settings tab:

• In the Allow drop-down list, select the List item.
• In the Source box, specify the range that contains the drop-down list items (in this example, the range is D1:D8).
• Check the In-Cell Dropdown option to show the drop-down list.

  Otherwise, Excel validates your data entry but does not show the drop-down button to select items from the list.

   5.   Click OK.

Notes:

• You can hide the range of values used in the Source box or cre
  how to write list in excel cell
  how to number list in excel cell