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

You can not put controls in cells. Controls float above the worksheet and
may or may not connect their results and behavior to the underlying cells.
So you can make something that looks like checkboxes in cells, or cells that
look like ckeckboxes, but it grows messy pretty fast and will be very
awkward to operate from a keyboard.

The dropdown list is Data validation. See
http://www.contextures.com/xlCondFormat01.html on this, it's very useful.

HTH. Best wishes Harald

"Kathy" <Kathy @discussions.microsoft.com skrev i melding
...
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

"Harald Staff" skrev i melding
...
The dropdown list is Data validation. See
http://www.contextures.com/xlCondFormat01.html on this, it's very useful.

Apologies for the wrong link, a "copy" action didn't do the job. Should be
http://www.contextures.com/xlDataVal01.html

Harald

THANKS VERY MUCH, THIS HIT THE SPOT!

Kathy

"Harald Staff" wrote:


"Harald Staff" skrev i melding
...
The dropdown list is Data validation. See
http://www.contextures.com/xlCondFormat01.html on this, it's very useful.

Apologies for the wrong link, a "copy" action didn't do the job. Should be
http://www.contextures.com/xlDataVal01.html

Harald

Cool, thanks for the feedback!
Best wishes Harald

"Kathy" skrev i melding
...
THANKS VERY MUCH, THIS HIT THE SPOT!