Fill Data AUTOMATICALLY With Your Own CUSTOM LIST #shorts

do you find yourself typing out the same list maybe you have it somewhere and you keep copying and pasting it over to excel no no no don't do that here's what you want to do type out a name that's a part of your list and then drag it down yeah everything magically appears even if you press Ctrl n and open a brand new sheet just type one of the names and drag down how does this work very simple go to file options Advanced go all the way down until you find custom lists here you can manually add the names that you want you just do it once or if you already have it in Excel select it and click on import you're going to see the custom list here then click on OK and ok now your custom list is there every time you press Ctrl n and you start off with one of the names that's a part of your list you just need to drag it down and you don't have to worry about typing manually or copying and pasting from another file

Channel: Leila Gharani

Views: 102,039

Keywords: XelplusVis, Leila Gharani, Advanced Excel tricks, Excel online course, Excel tips and tricks, Excel for analysts, Microsoft Excel tutorials, Microsoft Excel, Excel 2016, Excel 2013, Excel 2019, XelPlus, Microsoft 365, Excel 365, custom lists, excel tips, excel tricks, excel lists

Id: Xl09asNegcA

Length: 1min 0sec (60 seconds)

Published: Sun Oct 16 2022