Autofill not working

[RCOB]

Hi all

Autofill has ceased working on worksheets within an existing workbook. On older sheets the function works as intended on numbers and dates. Now the option is not present.

I have tried all the usual ways to auto fill and swithed on and off the function in the options menu but to no avail. Dragging on the bottom corner of a selection just copies the first line. The fill drop down menu in the editing ribbon is grayed out, and the icon which appears on the bottom left of a selection contains 'Quick Analysis' options and not fill options.

[davesexcel]

I have noticed the autofill does not work for me as well sometimes.

I use the right mouse button instead of the left mouse button in those situations.