Auto-Complete, in Microsoft Excel, can be an amazing feature, or a complete headache to master. When used properly it can literally save a user hours and hours by not having to type in entire texts or spend wasted time scrolling through hundreds or thousands of lines to find the text you are looking for.
After spending years studying how Excel handles this Autocomplete feature, I have put together a comprehensive training video based on everything I have learned and used in my applications with these auto-complete and auto-fill features. After this short video you will be an expert as well.
The basic idea is based on my own “Don’t Break The Chain” model in which I discuss how Excel uses this ‘chain’ to locate items within a column to present to the user within the auto-complete drop down list that is available on pressing Alt + Down Arrow. It’s easy to confuse this with the same validation drop down list that is used to validate data entry however the autocomplete list is based on values currently in the same column, hidden or not.
Now there are 2 ways to Download Your Free Workbook: