MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel data validation list

Posted by Doug on May 17, 2001 9:27 AM

Is it possible to set the width of a drop down list in Data Validation
to be wider than the column width? The cell to the immediate right will
have another drop-down selection, but will have no entry on the
same row, so the remaining text extends into this cell (which is what I want).
I do not wish to make the column wider because of printing. Is there an easy
formating solution?


Posted by mseyf on May 17, 2001 1:43 PM

You may wish to consider using a combo box or list box from the 'Control Toolbox' toolbar. they are a little more flexible than data validation for displaying choices.