Here you can learn how to Enable auto fill option into Excel
Process A:
1: Click on the “Formula Tab”
2: Click on “Calculation Option”
3: Select “Automatic”
If you have already enabled fill handle and cell drag & drop
but still excel auto-fill option working then Please follow the below Steps
Process B:
1) Click on the “File” Menu
2) Click on “Options”
3) Click on “Advanced”
4) Check-mark on or “Enable fill handle and cell drag & drop”