HomeMicrosoft OfficeExcelHow to insert radio buttons in Microsoft Excel ?

How to insert radio buttons in Microsoft Excel ?

In Microsoft Excel 2016 , you can easily create or insert radio buttons in the worksheet using the Form Controls in the Developer Tab.

How to insert radio buttons in Microsoft Excel ?

1. Open your worksheet in Microsoft Excel 2016 and navigate to Developer Tab and then select the Insert dropdown list under the “Controls” group. This will display the list of controls available. Select the radio button from the list.

image

2. Move the mouse on to the cell where you want the radio button to be inserted and draw or drop it.

image

3. Select the cell and drag the Auto Fill Handle to the range of cells where you want the radio buttons to be displayed.

image

4. The Radio buttons should be inserted as per the needs. You can now modify the text for each radio buttons by right clicking on the cell and selecting “Edit Text” option from the context menu.

image

    1 Comment

  1. arshad
    November 16, 2017
    Reply

    great presentation about excel thanks for sharing

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021