Option Button In Excel

In this lesson you will learn how to insert Option Button (aka Radio 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.

Edit Text

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.

Cell Link

Cell linked

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.

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

You can download the Template here – Download