How do I create a tick box in excel

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.
 
J

Jon Peltier

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
how do i get tick boxes on excel 2007? 1
Making a "Check Box" Larger 1
Tick box how do i? plz 1
How do I display a 'tick' on excel 2007? 1
tick box in excel 1

Top