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.

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

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

Back
Top