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. Enter or select a cell by using Cell link.Īfter binding, click on an option button to see the index of selected option button in the cell.īy default, Excel assumes all option buttons in a worksheet are related with each other.On the other hand, you can bind your option buttons to a cell to retrieve the index value of the selected option. If you only need this control as a visual element, you can start to use your option button right away. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |