In this lesson you will learn how to insert 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 Option 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 Option 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.
Further reading: Chart with option buttons How to create a chart with scrollbar? Group Box