View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
yogamitch yogamitch is offline
external usenet poster
 
Posts: 3
Default How can I insert a checkbox into a cell in Excel?

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.