Forum Discussion
Excel Spreadsheet versus Google Spreadsheets
As John was writing his response, he may not have been thinking about possible effects of changing the UI, such as having to update documentation/user manuals.
BTW, a Form Control checkbox in Excel puts a TRUE or FALSE value – not a checkbox (character or image) – into a cell, though that action is not by default. Caption text for the checkbox is optional.
<< 1) I can't seem to place a checkbox that is specific to that cell. >>
What research did you do? (rhetorical question) I did a Google search on "Microsoft Excel how to assign checkboxes to cells" and got relevant hits, including:
How to Insert a Checkbox in Excel (With Examples)
and How to Insert Checkbox in Excel (to Create Interactive Lists and Charts)
(I don't know why those articles used an absolute cell address.)
Is there a way to assign a checkbox to a cell
Unfortunately, as a Form Control checkbox typically needs a "manual action" to be linked, see a related video also in the search results:
Shortcut To Link All Check Boxes To Cells With A Macro In Excel || Excel Tricks
You may or may not want the linked cell to be the cell in which the checkbox control is located.
<< 2) The new spreadsheet needs to have the ability to create multiple checkboxes easily… >>
Then VBA code will have to be written, it seems, and invoked upon some event that happens to the worksheet (dependent upon your design). Does your company have the infrastructure to allow users to safely use (certain) macro-enabled Excel workbooks? If so, you're good to go till your next question.