You can change the label by right clicking the option button and selecting Edit Text. First of all, you can change the default "Option Button 1", "Option Button 2", etc. Now, let's take a look at further configuration options for inserting an option button. Hold down the mouse button to create big enough group box to fit all option buttons. The Group Box command can also be found under the Insert button. This is necessary for using multiple option buttons in the same worksheet. You can bind each option button in different groups to different cells.
To gather option buttons into multiple groups, you need to combine them under Group Boxes.
Click anywhere to insert a default option button, or hold and drag the cursor to define the size of the option. When you click the Insert button, you will see the same controls under two sections:Ĭlicking the Option Button button changes the cursor into a plus. Once the Developer tab is visible, you can find the Option Button command under the Insert button in the Controls section.
You can see detailed steps at How to display the Excel Developer tab for using advanced features.