Display more than 8 lines in an Excel dropdown box

Giganews Newsgroups
Subject: Display more than 8 lines in an Excel dropdown box
Posted by:  Brettjg
Date: Tue, 13 Jun 2006

Using Data Validation I can only get the drop-down box to display a maximum
of 8 lines, otherwise I have to use the scroll bar at the side to see the
other entries. Is there any way to set it so that it displays 12 or 15 lines
without having to scroll. The problem being that if the cell was blank to
start with the dropdown goes to the first entry after the last non-blank.

Replies