create pull down menu

A

amy chan

I would like to create a sheet for user input data to it as followin
example , the first column is duplicate .

name ID
==== ===
peter 123
mary 456
peter 452
tom 125
peter 544
john 524

kity 144
tom 524
vivi 521
peter 572
"
"


As you see in above , the user input the name field "peter" and "john
many times , I just would like to ask how to make the uesr no need t
re-type "peter" and "john" , can it create something like pull down men
for user to select from name list or is there other method for user n
need to re-type "peter" and "john" many times ? thanks

eg.
pull down menu
peter
john
mary
tom
kity
viv
 
C

Claus Busch

Hi Amy,

Am Mon, 18 Nov 2013 02:07:16 +0000 schrieb amy chan:
name ID
==== ===
peter 123
mary 456
peter 452
tom 125
peter 544
john 524

kity 144
tom 524
vivi 521
peter 572

if you fill the name column without blank cells and Peter already exists
in the column you get the suggestion Peter while writing P and you can
confirm it with Enter.
For me this way is easier and faster than clicking on dropdown, looking
for the name in the list and select it.
If you want a dropdown then select the cells => Data => Data Validation
=> List and put in your names as source


Regards
Claus B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top