Using the Control Toolbar
 

Two questions:

1) How do I add check boxes to items? I see the check box on the Control
Toolbar but how do I add them to cells? Does the worksheet need to be
protected first?

2) There is a drop down list of items already in a cell on the spreadsheet.
It is not visible until one clicks the cell. Then you see the arrow and the
list. I would like to get into the list to put a value at the top that says
"choose an option" AND have that option show so that people know to click the
cell. Again, do I need to protect the worksheet?

Thanks very much,
Kathy

Hi Kathy,

1) You don't add them to cells, you place them on the worksheet. You can
align with cells, but they are not part of that cell. Just click the
checkbox, and then draw it on the worksheet.

2) I don't think you can put that it the DV box, but you can put that text
in the cell above.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kathy" wrote in message
...
Two questions:

1) How do I add check boxes to items? I see the check box on the Control
Toolbar but how do I add them to cells? Does the worksheet need to be
protected first?

2) There is a drop down list of items already in a cell on the
spreadsheet.
It is not visible until one clicks the cell. Then you see the arrow and
the
list. I would like to get into the list to put a value at the top that
says
"choose an option" AND have that option show so that people know to click
the
cell. Again, do I need to protect the worksheet?

Thanks very much,
Kathy

And you have another reply to your other post in .misc.

Kathy wrote:

Two questions:

1) How do I add check boxes to items? I see the check box on the Control
Toolbar but how do I add them to cells? Does the worksheet need to be
protected first?

2) There is a drop down list of items already in a cell on the spreadsheet.
It is not visible until one clicks the cell. Then you see the arrow and the
list. I would like to get into the list to put a value at the top that says
"choose an option" AND have that option show so that people know to click the
cell. Again, do I need to protect the worksheet?

Thanks very much,
Kathy

--

Dave Peterson