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.
--
Brevity is the soul of wit.


"yogamitch" wrote:

so is there anything I can insert into particular cells in order to select or
deselect them?

"Dave F" wrote:

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
--
Brevity is the soul of wit.


"yogamitch" wrote:

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.