width of ComboBox for data validation

G

Guest

Hi,

I've a cell with data validation. Only values 'x' and 'y' can be input. The
cell (column) has small width. When I enter the cell an arrow becomes visible
on the right side. Clicking the arrow gives a combobox with selectable
values. The width of the combobox is default the cell with plus the width of
the arrow.

Now in my case the width of the combobox is very large in comparison with
the default. And it looks very bad with 'x'and 'y'. How can I deminish that
width?

Thanks for help

Henk
 
J

Jim Rech

We do not seem to have any control over the drop down's width.

--
Jim
| Hi,
|
| I've a cell with data validation. Only values 'x' and 'y' can be input.
The
| cell (column) has small width. When I enter the cell an arrow becomes
visible
| on the right side. Clicking the arrow gives a combobox with selectable
| values. The width of the combobox is default the cell with plus the width
of
| the arrow.
|
| Now in my case the width of the combobox is very large in comparison with
| the default. And it looks very bad with 'x'and 'y'. How can I deminish
that
| width?
|
| Thanks for help
|
| Henk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top