Get instant live expert help on how to add checkbox in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

How to display a checkbox only when a cell condition is met
Solved by A. W. in 13 mins
Hundred of checkboxes in multiple columns. each checkbox linked to the cell it's in. Checkbox columns are sometimes separated by pure data columns... ie: column B will have 365 checkboxs. Column C will have dates... '01 Jan 18' etc..Column D will have 365 checkboxes... Each checkbox to be linked to the cell it's in. Not sufficient to manually link 365 x 7 checkboxes......!
Solved by F. B. in 12 mins
I need a checkbox inserted in every row from A7 to A21. Each checkbox is associated with the country to the right of it in column B. When a countries checkbox is ticked, the result should be that every mention of the countries name on the spreadsheet is highlighted.
Solved by V. U. in 29 mins
I'm trying to set up a formula where I have three checkbox options linked to the same cell. Example: If checkbox in cell A1 is selected it displays a price of $100 in cell B1, If checkbox in cell B2 is selected A1 displays $300, If checkbox in cell B3 is selected A1 displays $500. I tried using IF, but I can't figure out how it works with more than 2 options. Maybe I am using the wrong function for this task. Any help would be appreciated, Thanks, Aaron
Solved by M. B. in 19 mins
I have a sheet1 which has a form with 10 elements, and have the exact same sheet copied over to sheet2. On sheet 1 there is a checkbox before each of the 10 elements, defaulted to True. If you set any checkbox to false, the row it is in is hidden in sheet2. How do I get this done? I have an understanding of how to setup a checkbox associated with a TRUE/FALSE cell and I imagine i'll have to set the individual checkboxes with a "Checkbox" macro. Please see the provided document for clarifications on the question at hand. Thanks!
Solved by A. J. in 22 mins