Excel - Set default width for validation lists

Latest update on August 6, 2012 at 08:55 AM by jak58 .

You can configure Excel to make use of minimum width for displaying a list box.Upon the creation of a new sheet:

Format a column to the desired minimum width for the display of list.
Put in this column a validation list.
The width obtained remain in memory as a minimum for all validations list implemented in the leaf.
The reference column can then be used in a normal fashion.

Thanks to Vaucluse for this tip.

Excel drop down list width
Excel data validation list from table multiple columns - How-To - Excel
Reset gimp settings default - How-To - The Gimp
Set default photo viewer windows 10 - How-To - Windows
How to set default video quality in facebook - How-To - Facebook
Wordpad set default font - How-To - Office Software

This document, titled « Excel - Set default width for validation lists », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

VBA VB6 - When the test DIR (directory) goes down

VBA - Create a series of buttons on a Excel worksheet

Subscribe To Our Newsletter!