Share via

i want to set a 'yes / no' drop down box, can you help me to do this?

Anonymous
2011-07-29T09:04:55+00:00

how do I set a 'box' in excel to put the answers I want someone to choose from?

i.e. Yes or No

thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2011-07-29T09:33:34+00:00

    Hi,

    I would do this with 'Data Validation.

    Somewhere out of the way enter Yes and No in 2 cells then select the cell where you want this dropdown and:-

    Data tab|Data Validation|DataValidation|Select 'List' in the 'Allow' Box.

    Click the small icoun to the right of the 'source' box and navigate the where you entered Yes/No and select thos 2 cells by dragging with the mouse. OK out and your done.

    Tip. To make them visible i always apply a background colour to data validation cells.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest