Is there a way, using Microsoft Excel 2003, to have the sheet auto complete a word after typing only the first few letters. What I would like to do is simply this: I want the user to enter the first letter of someone's last name in a cell and have the choices from an established list elsewhere in the sheet narrowed down with each typed letter.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!