| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list in a cell
I believe there is a way to make a cell have a list of availbale entries in like a drop down list but im not sure how to do it ? -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=546817 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drop down list in a cell
Go to Data-Validation. Select "list" from the 'Allow:' section, then Excel will let you highlight cells that contain the items you want on your drop-down list. Or you could just type in the items, separated with commas. Hit OK and you'll be good to go. Brad -- bparker ------------------------------------------------------------------------ bparker's Profile: http://www.excelforum.com/member.php...o&userid=34940 View this thread: http://www.excelforum.com/showthread...hreadid=546817 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down List that has formatting of cell range Font ect. | Excel Discussion (Misc queries) | |||
| Creating a drop down list to change decimal value in another cell | Excel Worksheet Functions | |||
| How do I insert a drop down list in a cell using | Excel Worksheet Functions | |||
| Can a cell have a drop down list and can also be auto populated | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
