Combo Box

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

I notice a friends excel document that contain a drop
down box for selection in every cell, I know how to to go
to the control toolbox and add a combo box, but it never
fits the cells.
What are the steps for me to create that in a row of cells

Thanks Susan
 
Thank you, that was exactly what I was looking for, one
more question, is it possible to copy the validation from
one cell to another without having to repeat the steps?
Thanks
Susan
 
I thing, there is no combobox from toolbox. I thing, it's a combobox which
You can create form Menu Data->Check..
I don't know it name, because I have Office in not english version.
 
Hello,

its Data|Validation| in settings allow: list ,Source: You can either
choose a list within your worksheet or write it directly to the box
separating each with comma.

Jon-jon
 
Another way is to select your range to get the validation. Then set it all at
once.

If you use a formula, excel will adjust it just like it does when you copy a
formula down a column.
 
Back
Top