jwood
07-01-2017, 12:06 PM
I'm working with an older version of Excel, 2003. I've created some drop-down lists. I know how to add or remove items from the lists. What I want to do, though, is to extend
the number of items that are seen when opening the list from within the cell. Right now, the default seems to be only 8 items. To see the rest, you must use the scroll bar which becomes a hassle if you have to do it often enough. Some of my lists I would want to have show 10 items. Some 15. Without scrolling. Anyone know how to do this? Probably everyone. :)
Thanks, Jack
the number of items that are seen when opening the list from within the cell. Right now, the default seems to be only 8 items. To see the rest, you must use the scroll bar which becomes a hassle if you have to do it often enough. Some of my lists I would want to have show 10 items. Some 15. Without scrolling. Anyone know how to do this? Probably everyone. :)
Thanks, Jack