From the drop down menu select View Code. Right click on the Toggle button (make sure the Design mode is selected). Note: you can change the color of the Toggle button, the font, font style, font color and even the name of the command button by right clicking on it and going to properties(make sure design mode is selected). Select the Toggle Button in the ActiveX Controls.ĭrag the Toggle button on your Excel worksheet. Now click on the DEVELOPER tab and select Insert. The developer tap is now visible and is present next to the view tab on the top menu bar. Click on the DEVELOPER check box (it is under Customize the Ribbon Main Tabs) and press Ok. Right click anywhere on the ribbon and select Customize the Ribbon from the drop down menu.Īn option dialog box will open. Note: you can skip step 1 and step 2 if the DEVELOPER tab is already open Either way you can see toggle button are very useful.įollow these steps to insert an Toggle Button in your Excel worksheet

For example you can use the toggle button to hide and unhide rows, hide and unhide columns, hide and unhide a chart, switch between design mode and edit mode or as an alternative to check box. The button alternates between an enable and disable state when it is clicked.

A toggle button is used to indicate a state, such as Yes/No or a mode such as On/Off. In this article we are going to learn how to insert and use a toggle button in Excel worksheet.