how do I insert tick boxes in excel
 

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

how do I insert tick boxes in excel
 

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Paul Homer" <Paul wrote in message
...
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

how do I insert tick boxes in excel
 

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.
--
Gary''s Student - gsnu200759


"Paul Homer" wrote:

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