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

 

[JoeMo]

If you want to fill like 1,2,3,4, ..., don't hold the ctrl key down, just drag the fill handle.

 

[michalfaron]

Hi JoeMo,
Maybe I sound like beginner, I am not. I have tried without ctrl - first, the result is shown on link.
A1 >1
A2 > 2
Select A1:A2
Drag bottom right corner
Result
1,2,1,2,1,2
Believe or not i know how auto fill and flash fill working I use it a lot - somehow it is disabled.

I reinstall entire Office 365 (original, I am not using any crack versions) and situation remain the same.

https://drive.google.com/open?id=1GO7znUnYHuYzkS5ZoMNUJ77R6DKHQdWJ

Any other ideas...

 

[michalfaron]

This is situation - when I use CTRL+E (shortcut for flash fill - it returns error)
https://drive.google.com/open?id=1UaXUxQ_7pSeorlqJG_OW4xwMSbY97pu5

This is my configuration: Option > Advanced
https://drive.google.com/open?id=1tCJ8mXmRZjLfOzsyubdvoepv4Eq-90tH

Every attempt I did is plain new workbook - so there is no filters in sheet1 whatsoever

No clue what to do ...

 

[Michael M]

With respect this sounds very much like a filtering issue, even though you have stated no filters.
Have you double checked for filters.
AND this is on a Mac right ?
If so, read here...the last post

https://www.bleepingcomputer.com/fo...e-in-excel-to-automatically-increment-values/

 

[michalfaron]

Hi Michael M.,
This is PC / Windows 10 with all updates / Excel 365 (paid)
Maybe this question sounds silly where i should check the "filter" issue in Excel?

m

 

[Michael M]

Usually on the Data Tab...Sort and Filter section....looks like a funnel !!
OR
on the sheet in question.....CTRL + SHIFT + L, turns filter ON and OFF

 

[michalfaron]

Michael,
I thought this is more sophisticated. As I mentioned - I am more than beginner
https://drive.google.com/open?id=10etSCnKFVa-cB3tJi0QcRfUWnXCayU1P

As you see there is NO FILTER involved in that plan new workbook on sheet1

So I need other ideas...

 

[Michael M]

Can you upload the fiel to dropbox....can't replicate the problem with a picture ???

 

[michalfaron]

There it is: https://drive.google.com/open?id=1iL94BHC_Q-1MyLxTspz7-vKcUTZ-SL5G