Fill Series greyed out...

[michalfaron]

My situation
Brand new workbook
All options checked/selected:
a. Options>Advanced>"Enable fill handle and cell drag-and-drop"
b. Options>Advanced>"Show quick analysis options on selection"
c. Options>Advanced>"Enable AutoComplete on cells values"
d. Options>Advanced>"Automatically flash fill"
e. Formula>Calculation options>Automatic

No filters - Brand new workbook
No hidden rows and columns

A1 > 1
A2 > 2
Select A1:A2
Right-bottom corner drag down with CTRL
You see - Fill Series is greyed out

Any ideas? https://drive.google.com/open?id=1C4AjlOGLDyb31Ueg5ukUL07r8lwS2SWk

 

[Michael M]

OK, I can't replicate the problem with your workbook
it works fine for me with the drag and fill.
It works with Fill series and it works with Autofill !
Only thing I can suggest is save the workbook and close, then do an open and repair.

OPTION
Just put the Number 1 in cell A1
Then Use CTRL + Drag to increment