As long as there’s a bit of ambiguity, you have to keep entering characters. ... If you’d like to learn more Excel data entry tricks, read How to reduce data input and typos in Excel.