drop down list with object
 

how to have a drop downlist with object like smiley

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

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

drop down list with object
 

There may be an Fn key that you can press, to use some of the letter
keys as the number keypad.

wrote:
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





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html