Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses

Smart Fill in Google Sheets is a new AI-powered feature that automatically detects patterns, generates formulas, and autocompletes columns. Google Sheets SmartFill automatically analyzes cells within a spreadsheet to assist you with data entry.

⬇️ Download the workbook here: https://pages.xelplus.com/sheets-smart-fill-file

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://www.xelplus.com/course/google-sheets/

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

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/

️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

RESOURCES I recommend: https://www.xelplus.com/resources/

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus

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