Fill Handle not numbering

%3CLINGO-SUB%20id%3D%22lingo-sub-2118468%22%20slang%3D%22en-US%22%3EFill%20Handle%20not%20numbering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118468%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20last%20few%20months%20I%20have%20not%20been%20able%20to%20use%20the%20fill%20handle%20to%20the%20number%20on%20excel.%26nbsp%3B%20When%20I%20pull%20the%20handle%20down%20all%20I%20get%20is%20the%20number%20repeated%20not%20a%20number%20sequence.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%20I%20will%26nbsp%3B%20put%201%20in%20the%20first%20box%20and%20pull%20it%20down%20and%20I%20will%20just%20get%20all%201's%20in%20my%20boxes%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20want%20I%20want%20is%201%2C%202%2C3%2C4%2C%20etc%20like%20it%20use%20to%20work%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2118468%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2118739%22%20slang%3D%22en-US%22%3ERe%3A%20Fill%20Handle%20not%20numbering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118739%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F960041%22%20target%3D%22_blank%22%3E%40Colescfb%3C%2FA%3E%26nbsp%3BIf%20your%20%22number%22%201%20is%20a%20text%2C%20it%20shall%20work.%20But%20if%20it%20is%20a%20real%20number%20you%20need%20to%20enter%201%20in%20one%20cell%2C%202%20in%20the%20cell%20below%20it.%20Then%20select%20%3CSTRONG%3Eboth%3C%2FSTRONG%3E%20cells%20and%20fill%20down.%20Now%2C%20Excel%20will%20recognise%20the%20pattern%20and%20add%201%20to%20each%20of%20the%20following%20cells.%20To%20my%20knowledge%2C%20that's%20how%20it%20always%20worked%20and%20still%20does.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

The last few months I have not been able to use the fill handle to the number on excel.  When I pull the handle down all I get is the number repeated not a number sequence. 

 

For example I will  put 1 in the first box and pull it down and I will just get all 1's in my boxes 

But want I want is 1, 2,3,4, etc like it use to work 

1 Reply

@Colescfb If your "number" 1 is a text, it shall work. But if it is a real number you need to enter 1 in one cell, 2 in the cell below it. Then select both cells and fill down. Now, Excel will recognise the pattern and add 1 to each of the following cells. To my knowledge, that's how it always worked and still does.