Use Data/Datavalidation/List
Set a list by typing vlaues seperated by coma or give a range of cells where
you can pur no of values that will be diplayed in the list.
the cell will not accept values other than in the combolist


"Alok" wrote in message
...
i want to add a combobox in a cell, and when i drag it down, want that it
applies to the next cell as well, like what normally happens when we drag
down a formula...
I saw in someone's excel sheet that this combobox appeared only when we
click that particular cell, otherwise , the cell appears to be without any
combobox. and when we drag it down, the combobox and its contents appear
in
the next cell as well.

how can i implement that? please reply...