How do I create a tick box in excel

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

Guest

I want to create a simple tick box in excel beside a list. Effectively the
tick box will either be ticked or not by clicking the mouse on it.
 
They're called Checkboxes, and there are two types. One is found on the
Forms toolbar (go to View menu > Toolbars, and select Forms), the other on
the Controls Toolbox (View menu > Toolbars, select VBA, then click on the
button with the wrench and hammer). You can link each checkbox to a cell,
which will display TRUE or FALSE depending on whether the box is checked. I
prefer to use the Forms version, but the Controls Toolbox version offers
more formatting options.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do you insert a tick in excel document 3
Show todays date if ticked 2
make box for users to tick or leave blank 1
Making a "Check Box" Larger 1
how do i get tick boxes on excel 2007? 1
I can no longer 'drag and drop' text. 6
Inserting tick/untick boxes in excel 2003 1
How do I remove (form) check-boxes from multiple excel fields? 2

Back
Top