How do I create a cell with a pickbox in Excel?
 

I would like to know how to make a cell in Excel that is a list of a group of
items.

How do I create a cell with a pickbox in Excel?
 

Maybe Data|validation.

See Debra Dalgleish's site for some notes:
http://contextures.com/xlDataVal01.html

JohnPWilks wrote:

I would like to know how to make a cell in Excel that is a list of a group of
items.

--

Dave Peterson

How do I create a cell with a pickbox in Excel?
 

Hello JohnPWilks,

I'm assuming you want a drop down list on a cell. If so:

Highlight all cells you want to put a drop down on and choose Data +
Validation. On the Settings tab choose List from the Allow arrow. At the
bottom type your list.
Eg. Cat,Dog,Fish.

If you already have your list in Excel:
In the bottom box of the Settings tab click the icon to the right and then
highlight the cells that contain your list.

You could also Name you list and type =Listname.

If you need any more help post back.

Judith

--
Hope this helps


"JohnPWilks" wrote:

I would like to know how to make a cell in Excel that is a list of a group of
items.