Ms Excel - Auto fill option is not working

Issue: 
Ms Excel - Auto Fill Option is not working / Not getting option to drag and drop to automatically fill the cells


O/S:
Windows

Solution / Workaround:

Looks like the Calculation option is changed somehow.

1. Click the File tab, and then click Options
2. Click Advanced, and then under Editing options, select or clear the Enable fill handle and cell drag-and-drop check box to show or hide the fill handle.
3. To avoid replacing existing data when you drag the fill handle, make sure that the Alert before overwriting cells check box is selected. If you don't want to see a message about overwriting nonblank cells, you can clear this check box.

Office Support link