resizing list width in combo box

A

Astericz

Hi all
I need some help in resizing list width in my combo box.

I use the DATA / VALIDATION tools and choose the LIST in the validation
criteria.
The list for combo box in sheet1 is fine. It can resize according to the
column width. But something is gone wrong in sheet2. The list is "stuck" in
the width approx. 45 (compared to the column width) and won't resize.

Any help please?
 

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

Similar Threads

Combo box 0
Excel Column Width in XLSX 0
Creating a Search using a combo box and then creating a report. 4
Combo or list box 0
Table Preferred width is changed when pasting 1
Adding a VLookup to an AutoComplete ComboBox 0
Data Validation drop-down width, with named range source (XL03 and 4
How to control drop down list width 4

Top