Friday, May 6, 2011

How to Create Combobox - Dropdown in excel 2007

We can create combobox value in the cell, we can try this as like this :

Open your Excel 2007, and create this value

image

Optional value will hide later.

Go to menu Data – Data Validation
image

And select your list range
image

And you will get this result :
image

Hope this step will help you to create combobox – dropdown value in excel cell.

Link File for this sample


No comments:

Hukum Tabur Tuai

Ingatlah hukum dasar ini, dalam kehidupanmu  Barang siapa yang menanam, dia pula yang akan menuai