Hey there stranger!

Sign up to get access.

How To Create An AutoFill in Google Sheets

About this Tutorial

Autofill inside of google sheets is possible with Dropdowns.

Featured Formulas

Video Transcript

 What's up? Welcome to Autofill. We're gonna create an autofill and how we're gonna do that, if you wanna know real quickly, we're gonna make a dropdown dropdown with data validation's. Gonna do that for us. Actually, before I go into any further, if that's all you want to know, here's how to do it.

So we might have a list, say of articles, all these titles and all these URLs, and we just wanna see what we wanna type it in. You know, something we might normally do.  is, if you know about this, if you have a list and you just start typing at the bottom of that list or at the top, and from the beginning, you'll have auto fill.

Media, you can do how, see it has autofill already, but if you're not, like how do you get that functionality? Well, you can do that with a dropdown menu with data validation. So you just do right click data validation and for your range, many times people will use a range of like a few to use a dropdown, like a selection.

But what we're gonna do is we're gonna do articles. We're gonna, actually, let me show you this, just.  data validation. Just click this and all we're gonna do is this entire column, so A to a and where is the button? There's the save button right over my head. And now we have a dropdown menu, which if you just click the this button, it's gonna try to load lot and it's just awful.

But if we just go to the cell, we can even, and we just start typing. Anything. See now we have a selection and it's a autofill and it's autofill of any, any word in that in there. So see, young, we wanna know all of everything. Maybe YouTube. . See? So like now we have an auto fill and that's all you need to know.

If that's all you came for, then that's all you need to know. What else I'm gonna talk about is why we might need an autofill. You might wanna do it if you are creating like a playlist. If you have maybe a hundred songs, like if you had billboard.  100 for the last 50 years, and you wanna only pick like 50 of the best songs.

And you just want to type in the names. You could put on this, this sheet, you know, all the names of those songs. And then starting here, if you just remembered a couple words . And also we might want to, you know, create collections in sort of a simple way. And there might be more information that you will wanna know.

So like out of, for all these articles, maybe I'm creating a list and I want to get the URL as well. So this dropdown menu is good to get the name, but what if I want other information? Well, I can use the lookup. So how that works.  is I just wanna search for that cuz we know that that's the key that we're searching for.

It's gonna be in range A to B and we won't column two. And actually want also false is it's not sorted. It enter. And now we have the url. Now we have the URL of each of these as we search for them. Let me see.

Just a list of articles from my newsletter that I picked just to get a lot of stuff. So like, here, we'll pick that and see. We now have a list of URLs for these as well. So what you can do is you can use V lookup, but what's gonna happen is, let me see if I can find it when there's a quotation mark.

Oh,  it, it did error out before, but there's another way. So there's.  The there's a problem here sometimes some of these will error out and I wonder if it got fixed since. Yeah, so it's, it's fixed now. But sometime you might want to also find, like this title will be in column B and you wanna do column A, and so you'll want to use index match for that to go equals index.

And we're gonna index on articles.

Eight to eight. And what we're gonna, oh, actually we we're, we want B to B, and what we're gonna do is match, and we're gonna search for this and we're gonna match it to articles 0.8 to eight. Zero. Do you want an exact match? And that brings up the same thing, right? So what that's really useful for is if we flip these around, if it, maybe we had the URL in column A and the title in column B.

See how all that last articles, see now these are errored and you can't do that, and you have to have the key in the left hand column. But now we have index match. We can figure that out.

So what's gonna happen too is like, if you wanna say get durations, you can use it here. If you have a playlist and you wanna get a running time, you can get all your durations here and then you can say, okay, this total time of all of these together is an hour. You can have sums if you wanna just pick out a few of these articles and you know the word count and you want to sum up all those.

Come, there's lots of different uses of this, but I just always thought that this auto fill was really cool and you can really be typing anything in and find exactly what you want and it'll match any word whatsoever. In here,

like, and it even highlights it. It's, it's a really simple thing. And, and again, you will almost never find this out because, you know, like this, this dropdown is mainly used for Dr.  drop down menus. So hopefully that helps you out with a cool, some cool projects you have.

Courses

Better Than Happy | Redesign of The Feelings Wheel

Best Header Font Ever

Learn to Love Your Sheets

How Starter Story Designs Data

Sheet Review! 150 Active VCs by LemonIO

Anika Asks: How To Set Text Overflow All The Time

Introducing: Brutal Calendar

Add a Checkbox to Turn on Dark Mode

00:05:10

Create Drop Shadows! This makes your dashboards pretty.

00:12:04

10 Things I Hate About Your Spreadsheets

Merge Cells for Dashboards

00:05:29

Dark Mode / Better Font Color

00:09:35

Better Font Colors

00:02:45

Magical Things You Can do with Checkboxes in Google Sheets

00:12:31

How To Export Your Beautiful Sheets to PDF

00:04:06

Consider Labels as Opposed to Headers

00:04:02

Add Icons To Your Sheets With a Domain Name

00:04:21

How To Color Cell Blocks So Others Enter Data Easily

00:10:30

Great Sheets! Corona Hiring Sheet

00:10:43

Great Sheets! Community Information Board by Seedtable.com

00:07:35

Roast: Hotel PPC Channel Cost Calculator

00:11:25

Better Header Fonts - Best Fonts To Use In Google Sheets

Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

00:09:49

Basic Keyboard Shortcuts To Speed Up Your Productivity

00:13:44

Basics - 5 Ways to Change Row Height

00:05:08

How to Refer to Other Cells - A1 and R1C1 Explained

00:13:22

Anders Asks: Can I Highlight Whole Row if Certain Columns have text?

00:09:31

Change the Default Font

00:03:33

Biggest Flaw In Dashboards with Dark Colors

00:07:45

Basics - 4 Ways to Change Column Width

00:05:48

Basics - Structure of a Sheet: Index() Row() and Column()

00:06:49

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

00:08:55

Use Cmd + Y To Do It Again, and Again, and Again

00:03:03

Create an Auto-Update Sales Chart: Trailing 12 Months

00:09:57

Google Sheet Basics - The Absolute Basics

00:09:48

Secure Your Sheets by BetterSheets.co

00:11:07

How To Create An AutoFill in Google Sheets

00:06:07

Build a Thermometer for Savings Goals

Make Your Lists Spicy Hot in Google Sheets

00:01:47

Restrict Access to a Cell if Another Cell is Blank

How to Use Smarket

00:03:28

Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!

00:06:23

Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!

00:53:31