How to add drop down in Excel sheet?

[Khushi]

How to add drop down in Excel sheet? Please share!

 

[Manish Singh]

To add a drop-down menu in Excel:

1. Select the cell where you want the drop-down.
2. Go to Data > Data Validation.
3. Select List in “Allow”.
4. In “Source” write comma-separated options (e.g., Yes, No, Maybe).
5. Press OK — the drop-down will be created.

This is very useful for feature forms, reports, or filters.

 

[jainnorton]

To add a dropdown list in Excel, select the cell(s) where you want the dropdown, navigate to Data > Data Validation, choose "List" under "Allow", and then specify the source of your list items (either by typing them directly, separated by commas, or by selecting a range of cells containing the items).

 

[niyati]

Steps to Add Drop-Down in Excel:​

1. Select Cell(s):
   Click the cell where you want the drop-down.
2. Go to Data Tab:
   Click Data > Data Validation.
3. Choose Validation Type:
   In the pop-up, under Settings, select:
   
   • Allow: List
4. Enter Values:
   In the Source box, type options separated by commas:
   Yes,No,Maybe
   OR
   Select a range of cells for the list.
5. Click OK.
   Now your selected cell has a drop-down list.

 

[shanewarne]

To add a drop-down in Excel:

1. Select the cell where you want the drop-down.
2. Go to the Data tab and click Data Validation.
3. In the box, choose List under “Allow.”
4. Enter your list items separated by commas, or select a range.
5. Click OK—your drop-down is ready!

 

[John]

To add a drop-down list in Excel, select the cell where you want the list. Go to the Data tab, click Data Validation, choose List under Allow, and enter your items separated by commas or reference a range. Click OK. Now, the cell will show a drop-down arrow with the selectable options.

 

[simran]

To add a drop-down list in an Excel sheet, select the cell where you want the list, go to the Data tab, and click Data Validation. In the dialog box, choose List under "Allow," then enter your options separated by commas or select a range of cells with the list items. Click OK, and the drop-down will appear in the selected cell.