Fill handle not increment a sequence

%3CLINGO-SUB%20id%3D%22lingo-sub-2312852%22%20slang%3D%22en-US%22%3EFill%20handle%20not%20increment%20a%20sequence%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2312852%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20guys!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20someone%20helps%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20excel%20is%20not%20incrementing%20a%20sequence%20when%20I%20use%20the%20fill%20handle%20function.%3C%2FP%3E%3CP%3EFor%20example%2C%20if%20I%20type%2C%201%2C%202%2C%203...%2C%20in%20the%20cells%20A1%2C%20A2%2C%20A3...respectively%20and%20select%20the%20range%20A1%3AA3%2C%20and%26nbsp%3B%20I%20pull%20down%2C%20it%20fills%20the%20next%20cells%20with%201%2C%202%2C%203%2C%201%2C%202%2C%203%2C%201%2C%202%2C%203...%20instead%20of%204%2C%205%2C%206%2C%207%2C...%3C%2FP%3E%3CP%3EI%20don't%20know%20what%20is%20happening%2C%20it%20always%20worked%20well.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Jluisnun_0-1619826199627.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277201iF1B0FE45BB7EBFBF%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Jluisnun_0-1619826199627.png%22%20alt%3D%22Jluisnun_0-1619826199627.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20checked%20in%20%22Options-%26gt%3BAdvanced-%26gt%3B%20%22Enable%20fill%20handle%20and%20Drag%20and%20drop%22%20it%20is%20marked%20as%20%22Enable%22.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Jluisnun_2-1619826553307.png%22%20style%3D%22width%3A%20491px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277203iC4F4E9131E6B76A7%2Fimage-dimensions%2F491x95%3Fv%3Dv2%22%20width%3D%22491%22%20height%3D%2295%22%20role%3D%22button%22%20title%3D%22Jluisnun_2-1619826553307.png%22%20alt%3D%22Jluisnun_2-1619826553307.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECuriously%2C%26nbsp%3B%20when%26nbsp%3B%20I%20click%20on%20%22Edit%20Custom%20Lists%22%20button%2C%20it%20doesn't%20open%20the%20window%20for%20edit%20list.%20this%20button%20is%20not%20working%2C%20it%20looks%20a%20kind%20of%20bug%20in%20the%20application.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Jluisnun_1-1619826402186.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277202iE67C507C5A8465ED%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Jluisnun_1-1619826402186.png%22%20alt%3D%22Jluisnun_1-1619826402186.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20anyone%20help%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2312852%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2313052%22%20slang%3D%22en-US%22%3ERe%3A%20Fill%20handle%20not%20increment%20a%20sequence%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2313052%22%20slang%3D%22en-US%22%3EYou're%20not%2C%20by%20chance%2C%20holding%20down%20the%20control%20key%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2313722%22%20slang%3D%22en-US%22%3ERe%3A%20Fill%20handle%20not%20increment%20a%20sequence%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2313722%22%20slang%3D%22en-US%22%3EHi%20JMB17%2C%3CBR%20%2F%3E%3CBR%20%2F%3ENo%2C%20I%20am%20doing%20exactly%20as%20before.%20I%20have%20used%20Excel%20for%20my%20years%20and%20I%20have%20never%20seen%20an%20error%20like%20that.%3C%2FLINGO-BODY%3E
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.

6 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

 

I have been having the same issue.  I confirm in the advanced tab that the enable fill check box is selected and I also confirmed calculations are set to automatic instead of manual.  Have there been any solutions to this?

@Jluisnun