how do I insert tick boxes in excel

P

Paul Homer

Hi,

I want to insert a column of tick boxes that can be selected or deselected
so as to choose whether to print some rows and not others.

How do I do this?

Thanks
Paul
 
B

Bernard Liengme

Can be done more simply with out check boxes
I have labels in A1:G1
I have data in A2:F100
The Print Area is set to A1:F100
G2:G100 has values either 0 or 1 (we could just as easily use x and blank)
I select A1:G100 and use Data | Filter | Auto Filter
I can filter the data on G so only row with G=1 are displayed or printed
Any use to you?
best wishes
 
G

Gary''s Student

In some cell enter:
P
In the cell below it enter an apostrophe follwed by a space
Format these cells as Wingdings 2

Now go to the column where the check boxes are required:

1. border the cells
2. format them as Wingdings 2
3. put Data Validation into the cells pointing to the two word table.

At this point, each cell in the column will have a pull-down allowing entry
of either a check mark or a blank.
 

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

Top