Hi Everyone
Could someone please point me in the right direction.
I have a data validation list that has approx 40 items.
When I select the cell with the drop down list - only 10 or so items appear . I then have to use the scroll bar on the side to look further in the list.
Is there a way that more than 10 or so ( possibly all ) items appear in the drop down box when the cell is selected - or is there a way that one can scroll down using the mouse wheel. ( I have to use the scroll bar at the moment ).
Please help
Thanks
Onesock
Bookmarks