Option Button

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.

Edit Text

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.

Cell Link

Cell linked


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.