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

Get EARLY BIRD ACCESS To the upcoming Private Mentorship Program where we will be creating amazing applications on exclusive weekly videos & a monthly Live Webinar. Add your Name and Email here and I will let you know as soon as the program launches: http://bit.ly/MentorshipProgram_EarlyAccess

THIS WEEK’S PROMOTION: Get $50.00 OFF the Amazing Advanced Excel Dashboard Reports Masterclass using coupon Code “50OFF”. Enroll today before this promotion ends. http://bit.ly/masterclass_50OFF

💯 Get 100 Of My Best Workbooks in One Zip File Here: http://bit.ly/100_Excel_Workbooks_ZipFile

📗 The Ultimate Excel Resource Guide, with 1000 Excel Resources, is the last Excel resource you will ever need. See all of the details here: http://bit.ly/1000_Excel_Resources_Guide

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

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing on YouTube here: http://bit.ly/ExcelForFreelancers_FreeTraining

I hope you love these videos, for More Free videos, personalized training and amazing tricks for freelancers, please find and follow us here:
Twitter: https://twitter.com/Excel4Freelance
LinkedIn: https://www.linkedin.com/in/excelforfreelancers/
Facebook: https://www.facebook.com/ExcelForFreelancers/

Share this post

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

Come On In

everything's where you left it.