Currently, if you use data validation with a list, it only shows 8 items before you have to scroll. I'd like to show more than that, is there a way to do that?
I tried using a combo box, but I would need a way for a regular cell in excel to reference what is in the combo box, and if the combo box could be constrained to the size of a cell.
Thank you