| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop down list with object
how to have a drop downlist with object like smiley
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
drop down list with object
You can create a list of symbols on your worksheet:
Select a cell, and hold the Alt key, then on the number keypad, type a 1 Press the Enter key, and the cell should contain a smiley face. In the cell below, use the same technique, but type a 2. Continue with the list to create a variety of symbols Then, use the technique shown here, to create a data validation dropdown list: http://www.contextures.com/xlDataVal01.html wrote: how to have a drop downlist with object like smiley -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
drop down list with object
I am using notebook I dont see number keypad
"Debra Dalgleish" wrote: You can create a list of symbols on your worksheet: Select a cell, and hold the Alt key, then on the number keypad, type a 1 Press the Enter key, and the cell should contain a smiley face. In the cell below, use the same technique, but type a 2. Continue with the list to create a variety of symbols Then, use the technique shown here, to create a data validation dropdown list: http://www.contextures.com/xlDataVal01.html wrote: how to have a drop downlist with object like smiley -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list shrinks as you go down column | Excel Discussion (Misc queries) | |||
| How do i have one Drop down list reference another drop down list | Excel Discussion (Misc queries) | |||
| Conditional Use of List box (drop down) | Excel Discussion (Misc queries) | |||
| drop down list of a drop down list | Excel Worksheet Functions | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Hybrid Mode
