Use of Check Boxes

  • Thread starter Thread starter stinger1
  • Start date Start date
S

stinger1

I'm interested in using a check box in a column on a worksheet. I would like
to be able to toggle the check box on or off to include or exclude the check.

Where can I find the help instruction for doing this?
 
I'm interested in using a check box in a column on a worksheet. I
would like to be able to toggle the check box on or off to include or
exclude the check.
Click to expand...

One way is to start with the "Forms" tool bar. Make this appear by right-
clicking in the toolbar area and checking "Forms."

Click on the check box in the Forms tool bar and then click in the
spreadsheet. This should make a check box appear. You can move it around
and resize it.

Then, using
Right-click > Format Control
you can change its appearance and behavior.

Most interesting is Format Control's "Control" tab. Using it, you can
assign a "Cell link," choosing a worksheet cell to store the state of the
check box (checked or not). This lets you do calculations based on this
state.

(I have Excel 2003.)
 
Back
Top