Hi, this is Wayne again with a topic “Customize the Excel AutoFill Handle”.
In this tutorial, I will show you how to change or add to the predefined text series that are in Excel and that work with the autofill handle in a previous video that I made called excels autofill handle in depth. I showed you how to type in, let’s say Monday: click on Monday and use the autofill handle to click and drag down and notice. What happened Excel produced a series in the spreadsheet Monday through Sunday, and then it repeated it can work similarly for months and for other things as well. Let’S try jam for January, but one of my viewers named Paul contacted me and pointed out that there’s yet another way that you can use the autofill handle. If you click on the file tab in the upper left, you can go down to options and advanced and then go down to the very bottom of the list of options and you’ll. See that there’s a general section and one of the things that you can change in the general section is you can edit custom lists? It says, create lists for use in sorts and fill sequences. So I’ll click Edit custom list – and you can see it comes with a few predetermined custom lists that will work with the autofill handle.
Well, I would like to create my own new list, maybe instead of Monday, Tuesday, Wednesday etcetera I’d like to do that in Spanish. I should also put in the accents of course okay, so there we have the days of the week in Spanish. So now that I’ve got that whole list entered, I can just click, OK and let’s try it out I’ll click. Ok, again, click on the screen and I’ll put Lunas click on it use the autofill handle and I could click and drag and pull it all the way down to use the autofill handle or if there’s data already to the left or right of your autofill handle. You can just double click on the fill handle and it will extend it to the same degree to the same length as that data. That’S just adjacent to it.
Jumping back into the options. Once you get into options, you have to go to advanced and then edit custom lists at the bottom of that list of options there. I now have a custom list. I don’t really need that list, so I’ll go ahead and delete it.
Click, OK and notice that you can also import items into one of these lists, for example from your spreadsheet. So you could type out on your spreadsheet, a series that you would like to save in custom lists, and then you could click here to select that click here again and then click import. In this case, I don’t really need to do that so I’ll delete it out. So using this method you could put in just about anything, you want into a new list a custom list that will work with excels, autofill handle and just click.
Ok, click, OK, again and you’re good to go to use that custom list thanks for watching. I hope you found this tutorial to be helpful. If you did please like follow and subscribe and when you do subscribe, click the bell so that you’ll be notified. Whenever I post another video, if you’d like to support my channel, become a supporter of mine through my patreon account and you’ll see a link to that in the description below, and I want to give a quick shout out to my five-dollar patreon supporters. Thank you. So much for supporting my channel .
