How to create CUSTOM AUTOFIL LIST
After completion of below steps, click on blank cell, type "a" which is first letter in created new custom autofil series. Drag the AUTOFIL handle(pointer or Dot)
1) Click on Office button
a)Open excel sheet
b)Click on Office button
2) Click on EXCEL OPTIONS
3) Click on EDIT CUSTOM LISTS
4) Type the required details
5)Click on ADD
6)Required series is added to CUSTOM LIST
7)Click on OK
Create CUSTOM AUTOFIL LIST - Through Selection