I'd be grateful for some help please.
..... re-worded, hope this makes sense
I'm working on a spreadsheet with drop down lists (validation). Is there a way that I can make the list automatically select what I want from the drop down list rather than me physically having to click on the drop down selection arrow and then click on the word?
Whenever I work in columns with no validation, if a word is started to be typed in which is repeated above, it automatically types the whole word for me. Is there anyway this can be done in validation mode?