Microsoft Excel lets you add two types of buttons to a worksheet: option buttons and toggle buttons. Option buttons, also referred to as radio buttons, let you choose one item from a list. Toggle buttons are either enabled or disabled, allowing you to switch between two states, such as on and off. Once a button is inserted into your worksheet, you then assign it form or ActiveX controls to make it perform an action when clicked.
Open Excel and Click on "Developer" Tab
Open Excel and click on the "Developer" tab. If its not visible, click File, Options and then Customize Ribbon. Click the Developer check box within the Main Tabs list and click the "OK" button when youre finished.
Select Insert from the Controls group on the Developer tab.
Choose the Type of Button
Click the type of option button youd like to insert. Form Control and ActiveX Control are the two main categories. To insert a Form Control option button, click Option Button from the list of Form Controls. The names of the buttons appear when you hover the mouse over them. To insert an ActiveX Control option button, click Option Button from the list of ActiveX Controls.
Click the Cell on Your Worksheet
Click the cell on your worksheet where you want your option button displayed.
Format the Button
Format or edit your button properties to make it do something when clicked. For example, if you inserted a Form Control option button, right-click it and select Format Control from the drop-down menu to edit its properties. If you inserted an ActiveX Control button, right click your button and select Properties" from the drop-down menu.
Click "Insert" in Controls Group
Click Insert in the Controls group on the Developer tab in Excel.
Select "Toggle Button"
Select Toggle Button from the list of ActiveX Controls.
Click where Button Should Appear
Click your cursor in worksheet cell where youd like the toggle button to appear.
Right-click the button and select Properties to assign ActiveX controls to it.
You can also assign macro controls to option buttons. With an option button inserted into your worksheet, right-click it and select Assign Macro. Choose the macro youd like to use from the pop-up dialog box and then press OK.