Ask a question »

Excel - Set default width for validation lists

May 2016

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.

For unlimited offline reading, you can download this article for free in PDF format:

See also

In the same category

Published by jak58.
This document entitled « Excel - Set default width for validation lists » from CCM ( is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.