Using the Control Toolbar

[Guest]

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

 

[Bob Phillips]

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)

 

[Dave Peterson]

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