How can I insert a checkbox into a cell in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am an ambulance technician and am setting a basic spreadsheet up to
maintain a record of every patient. Thus, I need to be able to insert a
tick-box into specific cells in order to record the various treatments given.
I'm probably an idiot but I can only find a control which allows a 'floating'
box, and not one which refers to specific cells.
 
Checkboxes are objects which float on top of the spreadsheet, and therefore
are not tied to particular cells.

You insert a checkbox by opening the Control toolbar and drawing the box to
suit your needs. You will see in the formula bar something like the
following: =EMBED("Forms.CheckBox.1","")

Dave
 
so is there anything I can insert into particular cells in order to select or
deselect them?
 
Hi, upon looking into it, I figured out the following.

if you insert a check box, and right click on it, and select format control,
you can tell excel to tie the object to a particular cell. Click on the
Properties tab in the format control dialogue box and select the option "move
and size with cells." This seems to do what you're looking for.
 
Thanks for your efforts Dave. It solved the problem to an extent but has not
given me quite what I'd wanted to achieve! I think i'll just take the easy
option... Cheers!
 
Back
Top