software

Having created a list, name, the data validation route to allow in-cell drop
down, I find that only 8 of the 12 items are listed amp; need to use slider bar
to select some items. How can I change the size of the list please? I find no
options by right clicking.

Colo tells you how to do that he
puremis.net/excel/code/070.shtml
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;Prowlinquot; gt; wrote in message
...
gt; Having created a list, name, the data validation route to allow in-cell
gt; drop
gt; down, I find that only 8 of the 12 items are listed amp; need to use slider
gt; bar
gt; to select some items. How can I change the size of the list please? I find
gt; no
gt; options by right clicking.