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.
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.
Now that the Developer tab is accessible, move to Insert menu and select the ‘Check Box Content Control’ (from Form Controls) icon.
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.
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.
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.
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.