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. Next up, right click the checkbox, and click ‘ Format Control’ option for further customization of the checkbox. Don’t worry you can always move the checkbox by right clicking it, and dragging it to the cell you want. Simply drag and drop the checkbox to confirm where you want the checkbox to be placed. You can now draw the checkbox in any cell. Now that the Developer tab is accessible, move to Insert menu and select the ‘ Check Box Content Control’ (fr om Form Controls) icon. Click OK to access the Developer tab from the ribbon. Look for the Developer checkbox under the ‘ Customize the Ribbon’ menu and make sure it is checked. If it’s not, head over to File menu and then select the ‘ Options’ button. Today, we bring you a guide on using simple checkboxes in a Excel spreadsheet.įirst off, make sure that Excel 2013 has the Developer tab enabled.

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.

Consider a scenario where you’re counting the total number of employees, who reached the office on time. 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. This version fixes a problem that may cause Office apps, such as Word, Excel, or Outlook to freeze or perform very slowly when you scroll the window or when you copy and paste text.Adding check-boxes to Excel 2013 spreadsheet can help you easily implement conditional functions without having to use any complex formulas. This version fixes a crash that may occur during the installation process. You don't need to download the separate updates listed in the KB articles. Click-to-Run updates include all the fixes listed in the KB articles.

The KB articles listed below are for reference purposes only.

Ms excel 2013