Jun 11, 2014 - With Kutools for Excel's Batch Insert Option Buttons feature, you can. After renaming the option button, you need to give a group name for the. Radio buttons, which are also called option buttons, provide a quick way for users of your custom Excel forms to quickly answer questions with a small, clearly defined set of options. For example, you can provide radio buttons to let users quickly select their age range: 10 to 30, 30 to 50, or 50+.
How to Add Checkbox and Radio Button in Excel?. Activating developer tab in Excel.
![Make Make](/uploads/1/2/5/3/125355229/836380854.gif)
Adding radio buttons or option buttons in Excel. Adding checkbox in Excel. Customizing checkbox and radio buttons in Excel 1.
Activating Developer Tab in Excel Now for adding checkboxes and radio button or option button in Microsoft Excel, you need to have activated in the menu bar ribbon. The developer tab allows to add more options to your spreadsheet in Microsoft Excel. Generally you can add all like button, scroll bar, combo box, list box, etc. In our case, we are going to activate developer tab for adding checkboxes and radio buttons in Excel sheet. Right click on the menu bar at the top of your screen in Excel and click on ‘Customize the Ribbon’ option. You can also click the small gear settings button at the right corner of the ribbon and go to customize ribbon option. Otherwise go to “File Options Customize Ribbon” menu.
Enable Developer Tab in Excel 2. How to Add Radio Buttons in Microsoft Excel? Adding up the radio buttons on your Excel sheet is easy when you’re done with activating developer tab. Here, we are taking an example in which we are going to make an ‘Attendance Record’. It’s up to you can do it on any sheet or in your current worksheet. We have made a ‘Roll no’ Column, a ‘Student Name’ column and a ‘Status’ column. Except for Status Column we have filled some sample data in other columns as shown below.
Dragging to Copy Radio buttons in the Column Now, let’s learn about how you can add checkboxes to an Excel sheet. How to Add Checkbox in Microsoft Excel? Adding up checkboxes in Excel sheet is as easy as adding up the radio buttons like we have done before. Now the thing is we need to make a different example for the checkboxes because checkboxes have different role than the option buttons. For this, we are taking an example of ‘Student Opted Subject’ table in which we are going to show that each student can either choose one or more subjects. We have left the column ‘Subjects opted’ blank because here we are going to add some checkboxes with different name of the subjects.
Checking Multiple Checkboxes By default Excel will show the name as ‘Check Box 1’, ‘Check Box 2’, etc. You can right click and edit the text as per your need. Formatting Checkboxes and Radio Buttons in Excel Adding the form control elements like checkbox or radio button is easy in Excel as explained above. Similarly you can customize the feel and look of the elements by right clicking and choosing “Format Control” option. You can change the background color, outline color and line width of the elements.
Choose the default option as checked or unchecked. Protect the elements when the Excel sheet is protected.
Resize or move independently or along with the cell. Below is an example of customized option or radio button and check box.