Ask a question »

Excel - Set default width for validation lists

May 2015


Excel - Set default width for validation lists





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:
Excel-set-default-width-for-validation-lists.pdf

See also

In the same category

Published by jak58.
This document entitled « Excel - Set default width for validation lists » from Kioskea (en.kioskea.net) 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.