How To Insert Checkboxes In Excel 2013 Spreadsheet

By Bilal Ibrar
In MS Office

Adding check-boxes to Excel 2013 spreadsheet can help you easily implement conditional functions without having to use any complex formulas. While the checkbox in Excel 2013 allows you to operate on boolean values, you can easily link any if-else statements with check boxes’ values (TRUE/FALSE) to get the condition-based results. Consider a scenario where you’re counting the total number of employees, who reached the office on time. Using the checkbox for on time and not on time for the relevant employee time log sheet, you can quickly check how many employees came in late. Today, we bring you a guide on using simple checkboxes in a Excel spreadsheet.

First off, make sure that Excel 2013 has the Developer tab enabled. If it’s not, head over to File menu and then select the ‘Options’ button.

Excel 2013

Now, select ‘Customize Ribbon’ menu. Look for the Developer checkbox under the ‘Customize the Ribbon’ menu and make sure it is checked. Click OK to access the Developer tab from the ribbon.

Excel 2013

Now that the Developer tab is accessible, move to Insert menu and select the ‘Check Box Content Control’ (from Form Controls) icon.

Excel 2013

You can now draw the checkbox in any cell. Simply drag and drop the checkbox to confirm where you want the checkbox to be placed. Don’t worry you can always move the checkbox by right clicking it, and dragging it to the cell you want. Next up, right click the checkbox, and click ‘Format Control’ option for further customization of the checkbox.

Excel 2013

Under the Control menu, you can choose if you want to have the checkbox Unchecked/Checked by default. The Cell Link option will allow you to place a Check/Uncheck status on any cell of your liking, which is represented by True/False.

Excel 2013

The use of check-boxes can be pretty handy in making all sorts of forms in Excel 2013. Below (as shown in the screenshot), we have used check-boxes to make a very simple form showing the availability of items in a garment shop.

Excel 2013 7

The form has a total of 5 items against which we have inserted 5 separate check-boxes. Each checkbox is unchecked by default. Selecting a checkbox shows its status (True/False) in the adjoining column. As mentioned earlier, here you can link the result of the checkbox with the desired function to get a condition-based result. For instance, if Hats checkbox is not checked, it can be set to show us Order Now message.

The above example demonstrates the basic usage of check boxes. However, you can  further enhance its application by linking the results with conditional formulas.

About "" Has 82 Posts

Bilal Ibrar
A marketing graduate with a passion for writing on topics related to social media, technology and business in general. Hobbies include gaming, animation and motorsports

facebook comments: