Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
missing cell borders in Excel | Excel Discussion (Misc queries) | |||
Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
Excel will not allow me to create a name of "C" for a cell! | Setting up and Configuration of Excel | |||
how do i create a blank cell in excel using a formula | Excel Worksheet Functions | |||
How do I create automatic cell movement when using excel | Excel Worksheet Functions |