width of ComboBox for data validation

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Back
Top