Excel 's Toggle Switch sets a variable to one of two values -- true or false. The control acts similarly to a check box, but looks like a button, so it suits cases where users must set single property rather than several options in a list. For example, suppose you have designed a spreadsheet to display sales figures for different products. A Toggle Switch may read "Show Last Quarter.

Add a check box or option button (Form controls) - Excel

Click "Toolbars" from the menu that opens. A submenu opens to the right of the main one. Click "Forms" if no check mark appears beside it. The forms toolbar appears as a floating menu in the spreadsheet.

How to insert radio buttons or option buttons in Excel?

Click and drag your mouse cursor over the spreadsheet to add the button to your sheet. Type a label for the button. For example, type "Show Last Quarter. Ryan Menezes is a professional writer and blogger.

He has a Bachelor of Science in journalism from Boston University and has written for the American Civil Liberties Union, the marketing firm InSegment and the project management service Assembla. He is also a member of Mensa and the American Parliamentary Debate Association. Skip to main content. Click "View" in Excel's menu bar. Click the "Button" icon in the toolbar.

The Definitive Guide; David Flanagan Using Microsoft Office Excel ; Patrick Blattne. Using Excel Controls to Change Chart Data; Timothy R. About the Author Ryan Menezes is a professional writer and blogger.

Suggest an Article Correction. More Articles How to Rename Columns in Microsoft Excel Queries How to Connect a Toggle Switch to a USB How to Use Logic Statements in Excel How to Configure an iPad's Mute Button.

Add a check box, option, or Toggle button (ActiveX controls) - Excel

Also Viewed How to Configure Percentages on a Sharp ElP How to Add a Line Between the Columns in an HTML Table in Microsoft Word How to Use Column Headings in Excel How do I Total Up All the Values in a Row in Microsoft Excel?

How to Add a Tweet Button to Your WordPress Blog Posts How to Display a Count of Cells on the Bottom of the Window in Excel How to Include All Rows for Filters in Excel. Logo Return to Top.

Contact Customer Service Newsroom Contacts. Connect Email Newsletter Facebook Twitter Pinterest Google Instagram. Subscribe iPad app HoustonChronicle.