How to add yes no dropdown in excel

Answer

To add a Yes/No dropdown in Excel, follow these steps carefully. The dropdown ensures data consistency and makes spreadsheets easier to use.

Steps to Create a Yes/No Dropdown

1. Select the Cell or Range
   Click the cell where you want the Yes/No dropdown. To apply the dropdown to multiple cells, select the entire range.

2. Open Data Validation

   • On Windows: Go to the Data tab → click Data Validation in the Data Tools group.

   • On Mac: Go to Data → Validation.

3. Choose Validation Criteria
   In the Data Validation dialog box:

   • Set Allow to List.

   • In the Source field, type:

     \(Yes,No\)
     

   • Ensure there are no extra spaces between the commas and words.

4. Enable Dropdown Display
   Check the box In-cell dropdown. This ensures a dropdown arrow appears in the cell.

5. Optional: Add Input Message and Error Alert

   • Input Message: Provide guidance when the cell is selected. Example: “Select Yes or No.”

   • Error Alert: Customize a message if someone types a value not in the list. Example: “Please choose Yes or No only.”

6. Click OK
   The selected cell(s) now display a dropdown with Yes and No as selectable options.

Notes and Tips

• You can copy the cell with the dropdown and paste it to other cells to replicate the dropdown.

• To edit the list, open Data Validation → modify the Source field.

• This dropdown works for both tables and regular cells.

Example Usage

Suppose you are tracking attendance:

• Column A: Name

• Column B: Attending?

• Column B can have a Yes/No dropdown. Selecting “Yes” indicates attendance, while “No” indicates absence.

This setup prevents typing errors like “Yse” or “N0” and maintains clean, consistent data.

This method is compatible across all Excel versions from 2010 onward.

Yes · 0 No · 0 Add Comment · 0

Add ·

Report