🆕👉Can I Mentor You? Learn how to define, design, develop and deploy your own Excel applications to earn passive income without having to trade time for money in my Mentorship Program today. Get all the details here:
Now there are 2 ways to Download Your Free Workbook:
Using Facebook Messenger here:
Using your Email:
💯 Get 100 Of My Best Workbooks in One Zip File Here:
Excel’s Auto-Complete feature has never been fully explained until now. Use this ‘Don’t Break The Chan’ method to fully understand exactly how you can make Excel’s autocomplete feature work for you.
Automatically and quickly find records in a list using 3 different methods to quickly locate records based on text you enter in a field. In this video I walk you through several amazing and simple methods to locate your records fast with AutoComplete
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:
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing on YouTube here:
I hope you love these videos, for More Free videos, personalized training and amazing tricks for freelancers, please find and follow us here:
Twitter:
Website:
LinkedIn:
Facebook:
Nguồn: https://pub-ed-inquiry.org/
Xem thêm bài viết: https://pub-ed-inquiry.org/category/cong-nghe
Excel For Freelancers says:
🆕Learn my secret system for creating & selling Excel applications in my Mentorship program right here: http://bit.ly/MentorshipProgram_YTCom
Now there are 2 ways to Download Your Free Workbook:
Using Facebook Messenger here: http://bit.ly/AutoComp_FbDl
Using your Email: http://bit.ly/AutoCompl_Wb
mapshops says:
Thank You so much, I was so frustrated why it wouldn't auto-complete the word, and it was that I broke the chain. Thanks for saving my sanity!
O.D.P says:
Hi There, I try this but it doesn't work, can you help me?
Evgenios Evangelos Gorgorinis says:
What about data validation? Wouldn't be easier to select from a drop-down list? Nice trick btw
Andrei Turcan says:
Hi, great job. Cannot download the template from the link. Thank you
Thiago Rios Barros says:
Doesnt working on my Excel version (Office 365)… Any idea how I solve this problem?
Bianka Telemaque says:
How do u enable this when u have VBA that prevents it?
Angel Batac says:
Thank you very Much!!!! No words could express my gratitude to you guys for me making this video!
MYute87 says:
Omg thank you. After many hours of failure, it worked. I didnt read anything about chains before today
rising surfer says:
Your channel is a treasure trove of Excel awesomeness, thank you!!
Somen Mondal says:
Nice a trick
mahamohan1 says:
Nice and informative.
Rock Badger Christianity says:
You need to work on slowing down and finishing your sentences. It gets frustrating to watch after a while. Just one way you could improve your content.
Friends Unite says:
I wish I could give you 5 thumbs, Thank you!
md.jahidul Islam says:
good
Simon Sim says:
Thanks a lot.
I'm a student in this channel from today.
Rune G says:
Just what I was searching for! Thanks!!
Buddha Computer Institute says:
hello sir I want make POS with barcode for small shop
Kai Socrius says:
I always found the Excel standard Autocomplete to be clunky, given that one had to type enough characters such that only one possible entry was left such that Excel would decide to complete it for you. I once worked on Excel Online, and found out the functionality that Autocomplete would give you every choice according to what you typed in, and I thought, where in the PC Excel application was this?
Right there on 3:50. You're saving me cumulative future seconds.
Andrea K says:
This is exactly what I was looking for. Sorry if you mentioned this… but can this be used with Data Validation tool? (newbie)… Thanks
Chris Wise says:
Search all over and you explained exactly what I was looking for. Thanks. Great job.
Hưng Nguyễn Cảnh says:
amazing <3
Manikandan Raja says:
Super :-):-):-):-):-)
C Toumi says:
Excellent trick – Thank you 🙂
Nilesh M Soni says:
Is there a way in Excel Auto complete where we just enter the word USA and it fills full United States of America?
Asiful lslam says:
Thanks for your video. It is so helpfull.
Can I open a specific workbooks by writing filename in a textbox and open it in a new window by pressing a command button?
If you have solution please share with me.
All of your videos have inspired me to learn ExCeL. Thanks a lot and waiting for your answer.
Wasel Housami says:
great tutorial
you saved my time
Subidha Basheer says:
Sir, its awesome for Someone beginner like me
Indian Monster says:
Can you Make Weight Converter in excel………………………………I have some problems face………so this subject sheet to help all production Line Employees ………………….
Pleased make it ……………
A sweet & Powerfull Topic …..
I hope you are make it…………
Its Newwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww Day……………..feeeeeeeeeeeeeeeeeeeeeel Gooooooooooooooooooooooooooood.
Ahmed Salim says:
nice info
Muhammad Ali Awan says:
Sir please make a complete software for school. Thanks in advance.
Sadam Hussain says:
How to Autocomplete number?
Entertainer 4 every1 says:
please try to teach ledger using advance excell work in one sheet your data will be save in multiples sheet. thankss