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 multiple columns - How-To - Excel
Excel- Activate a validation list based on specific criteria - How-To - Excel
How to set default date format in excel - How-To - Excel
Firefox set default zoom - How-To - Mozilla Firefox
Chrome set default zoom - How-To - Google Chrome

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