{"id":2896,"date":"2023-01-11T20:43:06","date_gmt":"2023-01-11T20:43:06","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=2896"},"modified":"2024-01-29T20:13:39","modified_gmt":"2024-01-29T20:13:39","slug":"how-to-insert-checkbox-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-insert-checkbox-in-excel\/","title":{"rendered":"How to Insert Checkbox in Excel for Interactive Checklists?"},"content":{"rendered":"

Insert Checkbox in Excel transforms your worksheets into dynamic, interactive documents, empowering you to take data tracking and user engagement to new heights. This versatile feature goes beyond static tables and forms, allowing you to create task lists, interactive surveys, and responsive reports effortlessly. With ‘Insert Checkbox in Excel,’ you’re not just entering data; you’re enhancing the user experience, promoting data accuracy, and streamlining processes. Embrace the simplicity and impact of this function to make your Excel workbooks more engaging and functional. Whether you’re managing tasks, gathering feedback, or building interactive dashboards, ‘Insert Checkbox in Excel’ ensures that your data is not just organized but also dynamic and user-friendly, making it an essential tool for modern spreadsheet excellence.<\/p>\n

This Content Covers:<\/strong><\/p>\n

    \n
  1. How to insert a checkbox in Excel<\/strong><\/a><\/li>\n
  2. How to edit the name of a checkbox<\/strong><\/a><\/li>\n
  3. How Fix the Position of a Checkbox in\u00a0Excel<\/strong><\/a><\/li>\n
  4. How to format a checkbox<\/strong><\/a><\/li>\n
  5. How to link a checkbox to a cell<\/strong><\/a><\/li>\n
  6. Inserting Multiple Checkboxes in Excel<\/strong><\/a><\/li>\n<\/ol>\n

    6.1 Using the Developer Tab<\/strong><\/p>\n

    6.2 Using copy Paste<\/strong><\/p>\n

    6.3 Drag and Fill Cells with Checkbox<\/strong><\/p>\n

      \n
    1. How to make an interactive checklist <\/strong><\/a><\/li>\n
    2. How to create a To-Do list with conditional formatting<\/strong><\/a><\/li>\n
    3. How to create an interactive report with checkboxes<\/strong><\/a><\/li>\n<\/ol>\n

      1. How to insert checkbox in Excel<\/strong><\/h2>\n

      Step 1:<\/strong> Select Developer Tab>>Insert<\/strong> and click on the Checkbox<\/strong> icon.<\/p>\n

      \"Insert<\/p>\n

      Step 2:<\/strong> Now click on anywhere in your sheet and a Check Box will be inserted.<\/p>\n

      \"Insert<\/p>\n

      2. How to edit the name of a checkbox<\/strong><\/h2>\n

      Step 1:<\/strong> After inserting a Check box if you want to change its name then select th<\/p>\n

      e check box and right-click on your mouse. Now select Edit Text<\/strong>.<\/p>\n

      \"Insert<\/p>\n

      Step 2:<\/strong> Change the name of your check box according to your preferences.<\/p>\n

      \"Insert<\/p>\n

      3. How to Fix the Position of a Checkbox in Excel<\/strong><\/h2>\n

      Follow the steps below after inserting a check box in your worksheet.<\/p>\n

      Step 1:<\/strong> Select your check box and right-click, then select Format Control.<\/strong><\/p>\n

      \"Insert<\/p>\n

      Step 2:<\/strong> Select Properties<\/strong> and then click on Don\u2019t move or size with cells <\/strong>and click OK.<\/strong><\/p>\n

      \"Insert<\/p>\n

      4. How to format a checkbox<\/strong><\/h2>\n

      Step 1:<\/strong> Right-click on your checkbox and select Format Control.<\/p>\n

      \"Insert<\/p>\n

      Step 2:<\/strong> Select Colors and Lines<\/strong> and create a format to your liking then click OK.<\/strong><\/p>\n

      \"Insert<\/p>\n

      5. How to link a checkbox to a cell<\/strong><\/h2>\n

      Step 1:<\/strong> Right-click on your check box and choose Format Control.<\/strong><\/p>\n

      \"Insert<\/p>\n

      Step 2:<\/strong> Select Control<\/strong> and click on Checked<\/strong> if you want the check box to be checked by default when you open your worksheet otherwise select Unchecked.<\/strong><\/p>\n

      \"Insert<\/p>\n

      Step 3:<\/strong> Type the cell location or select it from your worksheet inside the Cell Link <\/strong>box and click OK.<\/strong><\/p>\n

      \"Insert<\/p>\n

      Step 4:<\/strong> The selected cell is linked to that check box and whenever you check or uncheck the box, that cell will show True or False.<\/p>\n

      \"Insert<\/p>\n

      6. Inserting Multiple Checkboxes in Excel<\/strong><\/h2>\n

      By using some simple techniques, you can add multiple checkboxes in your worksheets.<\/p>\n

      6.1 Using the Developer Tab<\/strong><\/p>\n

      Follow the steps of \u201cHow to insert a checkbox in Excel\u201d<\/strong> and keep repeating it in your worksheet to have multiple checkboxes.<\/p>\n

      \"Insert<\/p>\n

      6.2 Using copy Paste<\/strong><\/p>\n

      Step 1:<\/strong> After creating a check box using the method shown before, right-click on that check box and click on Copy.<\/strong><\/p>\n

      \"Insert<\/p>\n

      Step 2:<\/strong> Right-click on the cell you want to paste that check box and select Paste.<\/strong><\/p>\n

      \"Insert<\/p>\n

      6.3 Drag and Fill Cells with Checkbox<\/strong><\/p>\n

      Step 1:<\/strong> Insert a check box in any cell of your worksheet and adjust the size of the checkbox so that it\u2019s completely inside that cell.<\/p>\n

      \"Insert<\/p>\n

      Step 2:<\/strong> Now select the cell and drag it down while clicking and holding the lower right corner of that cell.<\/p>\n

      \"Insert<\/p>\n

      7. How to make an interactive checklist <\/strong><\/h2>\n

      Follow the steps below to create an Interactive Checklist using the data given in the below picture.<\/p>\n

      \"Insert<\/p>\n

      Step 1:<\/strong> Insert a check box in cell B3 using the method shown before and rename it to DONE<\/strong>. Now to have a checkbox in all the cells click and drag the bottom right corner of cell B3 to B8.<\/p>\n

      \"Insert<\/p>\n

      Step 2:<\/strong> Press and hold Ctrl<\/strong> and click on the check box in B3 to select it and right-click on your mouse. Choose Format Control<\/strong> or use the Ctrl+1<\/strong> shortcut to make the Format Control dialogue box appear after selecting the checkbox.<\/p>\n

      \"Insert<\/p>\n

      Step 3:<\/strong> Click inside the box labeled as Cell Link<\/strong> and then select cell C3 and click OK <\/strong>to link that cell with the checkbox in B3.<\/p>\n

      \"Insert<\/p>\n

      Step 4:<\/strong> You must follow this step each time separately to link all the other check boxes of column B with cells of column C. Now check or uncheck the boxes to show the work list data as true or false.<\/p>\n

      \"Insert<\/p>\n

      8. How to create a To-Do list with conditional formatting<\/strong><\/h2>\n

      Step 1:<\/strong> Follow Step 1, Step 2, and Step 3<\/strong> of \u201cHow to make an interactive checklist \u201c, <\/strong>to create checkboxes and link them with the cells of column C.<\/p>\n

      \"Insert<\/p>\n

      Step 2:<\/strong> Select the range of cell A3:A8<\/strong>, click on Conditional Formatting under the Home tab, and select New Rules.<\/strong><\/p>\n

      \"Insert<\/p>\n

      Step 3:<\/strong> Select Use a formula to determine which cells to format<\/strong> inside the New formatting rule<\/strong> dialogue box. Now type =C3=TRUE<\/strong> inside the box shown below and click Format<\/strong>.<\/p>\n

      \"Insert<\/p>\n

      Step 4:<\/strong> Chose a format of your liking and click OK.<\/strong><\/p>\n

      \"Insert<\/p>\n

      Step 5:<\/strong> Whenever you check the boxes, you will see the formatting applied in column A.<\/p>\n

      \"Insert<\/h2>\n

      <\/h2>\n

      9. How to create an interactive report with checkboxes<\/strong><\/h2>\n

      Step 1:<\/strong> Add three checkboxes on top of the worksheet data and rename them into country names.<\/p>\n

       <\/p>\n

      \"Insert<\/p>\n

      Step 2: <\/strong>Create three additional columns named Checkbox, Linked Cell, and Country<\/strong>. Type the country names inside the cells of the Checkbox column exactly as they are in the Country column in this datasheet. The total amount will show in the Total box after you create the report.<\/p>\n

      \"Insert<\/p>\n

      Step 3: <\/strong>Link the checkboxes with the cells of column F under Linked Cell<\/strong> using the previously shown method of linking checkboxes with cells.\"Insert<\/p>\n

      Step 4: <\/strong>Select cell G4 and insert the formula given below and press ENTER<\/strong>. Now click and drag that cell to insert the formula in the other cells also.<\/p>\n

      =IF(F4=TRUE,E4,”-“)<\/strong><\/p>\n

      \"Insert<\/p>\n

      Step 5:<\/strong> Type the formula given below in cell D4 under Total<\/strong> and click ENTER. <\/strong><\/p>\n

      \"Insert<\/p>\n

      Step 6: <\/strong>Select column E to G and hide them.<\/p>\n

      \"Insert<\/p>\n

       <\/p>\n

      Application of Insert Checkbox in Excel<\/strong><\/h2>\n
        \n
      1. Task Lists<\/strong>:\n