This post will guide you how to insert and use a radio button or option button in Excel. How do I add option button (Form Controls) into your current worksheet in Excel. How to create radio button in Microsoft Excel 2013/2016.
Insert Radio Button
If you want to insert one or more radio button into your current worksheet, you just need to do the following steps:
#1 go to DEVELOPER tab, click Insert command under Add-Ins group. And click Optional button icon from the drop down men list.
#2 draw an optional button into your worksheet.
#3 if you want to create two or more radio button, just repeat the step 1 and 2.
#4 right click on the option button, and select Edit text menu from the pop up menu list. And then you can type one new name for that option button.
#5 right click on one option button, and select Format Control from the pop up menu list. And the Format Control dialog will open.
#6 switch to Colors and Lines tab, you can change the background color for the selected option button. Or you can change the option size (width and height) via Size tab.
#7 Let’s see the result.