tick box in excel

C

cheryl

can somebody please advise how you put a tick box or a combo box with a
yes/no into excel spreadsheet
 
M

Max

Perhaps an easier alternative via data validation ..

Try this ..

Assuming responses yes/no to be made in col B

Select col B
Click Data > Validation

In Settings tab:
Allow: List
Source: Yes, No

In Input Message tab,
enter: Select: Yes or No

Click OK
 
Top