You can use Data Validation to create dropdown lists. There are
instructions in Excel's help, and he

http://www.contextures.com/xlDataVal01.html


vayne wrote:
how do i create a listbox that shown thru-out every row without using macro?...


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html