Comments on: How to add, copy and delete multiple checkboxes in Excel

The tutorial will teach you how to quickly add multiple checkboxes in Excel, change the check box name and formatting, as well as delete one, several or all checkboxes on a sheet. Continue reading →

Table of contents

Comments page 2. Total comments: 63

  1. I found selecting multiple checkboxes quite clunky and difficult. An easier, albeit brute force, way to delete multiple checkboxes:
    1. select cells
    2. Ctrl+x
    3. Ctrl+v into a separate and new sheet
    4. Delete sheet
    Ahh, much less frustrating!

    1. You, sir, are a genius!

    2. Absolutely brilliant!

  2. Thank you , at last someone could explain to me how to get rid of check boxes.
    Straightforward and easy. Thank you

    1. Hi Gary,
      To delete individual checkboxes, select them (hold the Ctrl key and click on the checkboxes), and then press the Delete key on your keyboard.

  3. More people had asked the same thing and if you know it would be good to answer.

    We add a checkbox and link it to cell C1.

    We drag it down until cell C100.
    Unfortunately all the checkboxes are linked to cell C1.

    Is there a way to drag the checkboxes until cell C100 and each one to have a different link?

    C "previous" + 1 ??

    1. Hi, has anyone found a solution to this problem?

  4. I am building a spreadsheet using checkboxes in a calculation. But somehow I have a series of checkboxes where when I check one, they all show a check mark. How did I do that, and how can I make it go away?

    Thank you!

  5. Hi Svetlana,

    I have a couple questions.

    Do you know how to resize checkbox that contains the check mark only and not where the text is written.

    I have a couple checkbox on my form, but I need to remove only one. I'm unable to grab checkbox and remove it. Please advise how to do it.

    Thank you.

    1. Use the control button when trying to click the check box. This should allow you to select and edit rather than make the check mark appear/disappear.

  6. Amazing, thank you!

  7. is it possible to use a checkbox as a filtering mechanism. for instance, i have several columns in which a box is checked if the criteria is met for that row. for example in this spreadsheet for political supporters, i have columns for Veterans, 2nd Amendment, Women, State Party Member, etc. I would like to put a checkbox at the top of each column, that when checked, would then filter the display to only show those rows that have been checked for that criteria. that way i can see only the veterans, or only the women, etc.

    1. Change the range to a table, then use the filter buttons at the top of each column to select only those records you want to see.

  8. Hi
    I have linked a cell to a check box so that when its ticked the linked cell goes green. The check box is positioned over on the linked cell.
    I have dragged that cell down about 100 times so the following 100 cells share the same format and cell locations, etc.
    My problem is that since ive dragged down from, say cell A1, all the following check boxes copy A1's checkbox.
    So if i tick A1 checkbox, all other check boxes go ticked.
    Is there a way I can link each check box to the cell its above without having the manually change each one in the format settings?
    Ive tried writing it as $A1 and then dragging so the numeric part isn't fixed with a dollar sign but no luck.

    1. I too have this issue and I can't find a solution anywhere!

      1. Hello!
        We have already written that the reference to a cell inside a checkbox does not change when it is copied or moved.

    2. I have this problem too, it sucks that I have to change the lined cell manually

      1. I also have the same question. Its a shame this question still has not been answered.

    3. Hey David, did you find a solution yet on how to solve this problem?
      I have the same problem and can't find a solution.

      1. Me too :(

  9. Many thanks! Very helpful.

  10. Great stuff! Thank you.

  11. A question about inserting check boxes in multiple rows.
    Can I use a conditional formatting to have a check box be inserted in a cell if certain conditions are met in other columns?

    1. Hi Michael,

      It's not possible. With conditional formatting, you can only change the formatting of a cell such as fill or font color, border, etc.

  12. Useless. No more than the most basic information provided by Microsoft already. Why waste the time to duplicate and post it?

    1. Then why are you here... To complain?

    2. Hello David,

      This post is for beginners, and yes, it only explains the basics. We also have a few examples that show how to use check boxes to create a to-do list (completed tasks with the strikethrough format), interactive report and dynamic chart. Hope you will like these examples better.

  13. Thank you so much for this tip. After downloading my account statement in xls file I was disappointed to see a plethora of check boxes and drop down menus placed haphazardly in various cells. Your tip helped me to delete all the unnecessary check boxes and drop down menus through 'go to special' feature. Thanks once again.

  14. If multiple check boxes have moved upon saving is there anyway to have them revert back to their original positions.

    The document is very large and for some reason on 1 page of a workbook of 7 all check boxes on all lines moved up and to the left 4 cells.

  15. Thanks, informatic

  16. Please enjoy this

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)