I'm using data validation on some cells, but the drop menu only shows 8 entries in the default window. If I want entries below this I have to scroll down, which is taking a lot of time for the specific task I am doing.
I want to extend the drop window to show the first 20 list entries without having to scroll down.
Is there any way to extend the default set up of showing only 8 entries?
I want to extend the drop window to show the first 20 list entries without having to scroll down.
Is there any way to extend the default set up of showing only 8 entries?
