We’ll take a look at how you can add radio buttons to your spreadsheet and how to customize them easily.

How to Enable the Radio Button Feature in Excel

The option to insert a radio button in your Excel spreadsheet is part of the Developer tab. If this tab is missing from the ribbon, go through the instructions below to enable it:

Open the File menu and select Options. This should bring up the Excel Options window. From the right pane, select Customize Ribbon. Set Customize Ribbon to Main Tabs. Enable the Developer option. Click OK to save your new settings.

How to Insert a Radio Button

With the Developer tab enabled, you can now use several interactive controls to create professional-looking Excel spreadsheets. To insert a Radio button, select the Developer tab and go to Controls > Insert. There, click Form Controls and select Option Button.

The cursor should now turn into a + icon. Click anywhere inside the spreadsheet to insert the Radio button. Currently, the button has no function, as you have to connect it to a cell.

To link a radio button to a cell, right-click it and go to Format Control. There, select the Control tab and use the Cell link field to link it to a cell.

In general, you need two or more radio buttons to control your spreadsheet. Once you add multiple radio buttons, they will be linked to the same cell. As you select a different radio button, the linked cell will display a different value.

However, the radio buttons and linked cells have no real functionality unless you add a filter function to your spreadsheet.

How to Customize a Radio Button

Once you add a radio button, you should customize it so it’s easier to use.

How to Rename a Radio Button

If you insert multiple radio buttons in your spreadsheet, you should rename them for quicker identification. To do so, right-click the radio button and select Edit Text.

If you want to make Excel radio buttons really stand out, you can apply colors and borders. Right-click one of the radio buttons, go to Format Control, and open the Colors and lines tab.

How to Reposition a Radio Button

As you keep editing your spreadsheet, the radio button might move around and end up between two rows or columns. To keep your buttons from moving all over the sheet, right-click the radio button and go to Format Control. There, open the Properties tab, check the Move but don’t size with the cells option, and click OK.

If you want the radio button to be the same size as its cell, press and hold Alt as you resize it.

How to Delete a Radio Button

If you want to remove a radio button from your spreadsheet, select it and press Delete. This works fine if you’re working on a smaller spreadsheet with a few inserted objects.

But if you’re working on a large spreadsheet with many objects, your radio buttons might get covered by other objects, and you may have difficulty finding them. In this case, select the Home tab and head to Editing > Find & Select > Selection Pane.

This will display every inserted object, so you can quickly find and delete the radio button you want to remove.

Add Radio Buttons to Your Spreadsheet

This is how you can insert and customize radio buttons as you work in Excel. While this feature might be a bit tricky to use, especially at the beginning, it’s a great way to visualize or sort data while working on a large spreadsheet.

Learning to use Excel Radio buttons is just a step in becoming an Excel wizard. Fortunately, there are plenty of websites and blogs to learn Excel tips and tricks.