Option Button In Excel

Option Button In Excel

To insert Option Button to your worksheet you should go to the Ribbon. Click Developer > Insert > Form Controls > Option Button.

Next draw your Radio Button with your mouse.

Edit name

You can change the text on Option Button. Just right click go to Edit Text and change it.

Link with cell

To link Radio Button with cell right click and go to Format Control. Go to Control and write the address of the cell.

Survey

Using Option Buttons in Excel you can easily create your own survey in Excel. Here you have screenshot with example on survey in Excel.

These are Option Boxes in one Group Box. That’s perfect way to create survey in Excel.

Just put some Option Boxes inside one Group Box. You can also copy/paste it to Word or Power Point.

Template

Further reading: 
Chart with option buttons
How to create a chart with scrollbar?
Basic concepts 
Getting started with Excel
Cell References