tick box in excel

[Guest]

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

 

[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