• Fill in Excel can fill a range in a specific direction by using the fill handle. 
  • The range is filled with values, numerical, textual or a mix which are either copied from the initially selected cell or based on the pattern of the selected cells.  
  • The range can be filled downwards, upwards, rightwards, or leftwards.  
  • A fill handle is a small square appearing at the bottom right corner of a selected cell or range. 
  • Here we see how to create a list for autofill. 
  • Go to the file tab. 
  • Click options that Excel options dialog box opens from the pane on the left.  
  • Click advanced, though advanced options for working with Excel are displayed on the right side from the general section, click Edit custom lists. 
  • The custom lists dialog box opens under custom lists to the left there are some lists defined by the system. 
  • The user defined custom lists work the same way.  
  • The system defined lists work.  
  • Press the enter key after typing each entry in list entries. 
  • Once all entries have been entered, click add.  
  • Click OK twice and exit from the Excel options dialog box to check whether the user defined custom list works or not.  
  • Type the name.  
  • Drag the file handle name will be auto fill automatically.