How to add either radio buttons or checkboxes to an excel sheet?
 

I have a checklist people use to complete a list of tasks from an excel
spreadsheet, and i just have brackets like [ ] on the excel sheet. They
print it out and check things off with a pencil and keep hard copies.

I'd like to make it so that I can have checkboxes there instead, so they can
open an electronic copy of the file, click checkboxes as they complete tasks,
then save it for record keeping, rather than using hardcopies. Is there a
simple way to create checkboxes in cells?

How to add either radio buttons or checkboxes to an excel sheet?
 

View--Toolbars--Forms.

Draw the checkboxes where you want them.

Note these are considered objects which lie on top of the spreadsheet. You
can control how the checkboxes behave relative to the underlying sheet by
right-clicking and selecting Format Control. You can link a given check box
to a given spreadsheet cell by clicking the control tab in the Format Control
window and entering a cell address in the cell link box.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Cruanomics" wrote:

I have a checklist people use to complete a list of tasks from an excel
spreadsheet, and i just have brackets like [ ] on the excel sheet. They
print it out and check things off with a pencil and keep hard copies.

I'd like to make it so that I can have checkboxes there instead, so they can
open an electronic copy of the file, click checkboxes as they complete tasks,
then save it for record keeping, rather than using hardcopies. Is there a
simple way to create checkboxes in cells?