How To Use Excel’s AutoComplete Feature

Randy Austin

Randy Austin

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:

  1. Using Facebook Messenger here: http://bit.ly/AutoComp_FbDl
  2. Using your Email: http://bit.ly/AutoCompl_Wb

Got Excel Question? Let us help you with that, Join thousands of the worlds best Excel Experts in Facebook’s fastest growing @Excel For Freelancers Group right here: http://bit.ly/groupexcel

If you have ever wanted to be able to turn your Excel skill and passion into a lucrative passive income stream then I have just the program for you. 

I have spent the last 7 months putting together the most comprehensive program in which I will share with you all of my secrets that have enabled me to create and sell my Excel applications. 

In this Mentorship Program I will be releasing brand new private video training’s in 90 minute modules made up of smaller lessons. The first application we will be creating together is an amazing Accounting Application consisting of Invoicing, Inventory, Purchase Orders, an Email & Notification Center, Chart Of Accounts, General Ledger, Recurring Transactions, a Full Dashboard and it will have complete Share & Sync capabilities, and much, much more.

I will be sharing every aspect of the process, from concept to cash, including how to Define, Design, Develop and Deploy your own applications. If this sounds like something for you, then NOW is the time join. Lock in your early-bird price before they rise. Click here to join today: http://bit.ly/MentorProgram_WebsiteTues

Share this post

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
Share on email