Fill handle not increment a sequence

New Contributor

Hello guys!

 

I hope someone helps me.

 

My excel is not incrementing a sequence when I use the fill handle function.

For example, if I type, 1, 2, 3..., in the cells A1, A2, A3...respectively and select the range A1:A3, and  I pull down, it fills the next cells with 1, 2, 3, 1, 2, 3, 1, 2, 3... instead of 4, 5, 6, 7,...

I don't know what is happening, it always worked well.

Jluisnun_0-1619826199627.png

 

I checked in "Options->Advanced-> "Enable fill handle and Drag and drop" it is marked as "Enable".

Jluisnun_2-1619826553307.png

 

Curiously,  when  I click on "Edit Custom Lists" button, it doesn't open the window for edit list. this button is not working, it looks a kind of bug in the application.

 

Jluisnun_1-1619826402186.png

 

 

Could anyone help me?

 

Thanks a lot.

5 Replies
You're not, by chance, holding down the control key?
Hi JMB17,

No, I am doing exactly as before. I have used Excel for my years and I have never seen an error like that.
Hi JMB17,

No, I am doing exactly as before. I have used Excel for my years and I have never seen an error like that.

Thanks.
What happens if you enter 1 in a cell then use ctr+fill handle down?

Hi Patrick2788,

 

When I type 1 and hold "Ctrl" + Fill handle, it repeat 1, 1, 1, 1, 1, 1, 1...

 

Jluisnun_0-1620069013449.png