For example if you have a column of names and you’d like to get the first name of a person, you don’t have to write a formula. You just need to type the result you want and Smart Fill will recognize what you want and autofill the column with First names. The great benefit of Smart Fill is that it provides you with the formula for this. This means your results will automatically update.
Shortcut key to apply the Smart Fill results in Sheets is Control + Shift + Y.
Excel has a similar feature called Flash Fill. In this video we’ll find out what SmartFill can do and where are the differences to Excel’s FlashFill.
Join My Google Sheets Comprehensive Masterclass: https://courses.xelplus.com/p/google-sheets
*** Additional Bonuses are ONLY available on XelPlus.
Time Stamps
00:00 SmartFill in Google Sheets
00:53 How to Use SmartFill in Google Sheets
04:59 What Does Not Work in SmartFill (Yet)
07:52 How to Turn Off SmartFill in Google Sheets
08:23 Google Sheets’ SmartFill Pros and Cons
⯆ Check out the blog post here (Scroll down for link to file): https://www.xelplus.com/smart-fill-in-google-sheets
LINK to Google Sheet Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyy0mPWTS5JL99PySzLPiJYu
Excel Flash Fill video: https://youtu.be/1KimYFzET1w
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#googlesheets