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

You can use DataValidation. There are some instructions he

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

Susan wrote:
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

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

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
-----Original Message-----
You can use DataValidation. There are some instructions
he

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

Susan wrote:
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

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

.

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.

Uzytkownik "Susan" napisal w wiadomosci
...
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

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

"losmac" wrote in message
...
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.

Uzytkownik "Susan" napisal w wiadomosci
...
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

Yes, use Copy then Paste Special | Validation.

"Susan" wrote in message
...
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

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.

Susan wrote:

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
-----Original Message-----
You can use DataValidation. There are some instructions
he

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

Susan wrote:
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

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

.


--

Dave Peterson