Excel spreadsheets help you build interactive forms. These often include check boxes that users can click on. Let’s learn how to insert check boxes in Microsoft Excel.
How to Insert Check Boxes in Excel
An interactive check box helps users specify selections in spreadsheets that you share with them. To add a check box in Excel, you’ll be working in an area of the app called the Developer tab.
By default in Excel, the Developer tab isn’t automatically displayed. That means you’ll need to activate it in order to make use of its tools. To get started, click on the Excel dropdown in the upper left corner of your screen. From there, click Preferences.
This is a dashboard listing an array of Excel layout and customization options.
Click on Ribbon & Toolbar, then scroll down the list on the right side of the menu that appears. The option you want is Developer. Click on the box beside it, and finish by clicking Save.
You’ll now see the Developer tab appear on Excel’s ribbon. Typically, it will be placed immediately to the right of the existing View tab.
Click on Developer to open it up. You’ll see an array of options: combo box, label, and of course, Check Box, among many others. To add a check box, click on Check Box.
Hover over your spreadsheet, and you’ll see that your cursor has become a + symbol. Click once, and you’ll see an interactive check box appear on the sheet in the spot where you clicked.
By default, Excel names the box Check Box 1. However, the title works like any text box. You can easily replace the default title with words of your own.
As you can see, it’s easy to check and uncheck by clicking repeatedly. Excel makes it simple to insert check boxes to build amazing interactive spreadsheets quickly.
Chart in Excel