Hello, I have a complete column in which I want a list of values to appear. I used data validation to a complete column, but the problem was that there were a lot of values in the list that scrolling through those took a lot of time. So I wanted to use something to autocomplete what I typed from the list of values. I used combo box and it worked fine. But then what the problem was I wanted it to be used on each row of a column separately. by this method it was being used only in one cells and not all the cells in a column. Please help me with the same as its urgent. Thanks.
Bookmarks