Fill series

%3CLINGO-SUB%20id%3D%22lingo-sub-1378239%22%20slang%3D%22en-US%22%3EFill%20series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1378239%22%20slang%3D%22en-US%22%3E%3CP%3EJust%20want%20to%20start%20with%201%20and%20add%201%20to%20the%20next%20number%20so%20I%20have%201%2C2%2C3%2C4%20and%20so%20on%20down%20the%20page%20how%20had%20is%20this.%20The%20old%20fill%20function%20did%20this%20fill%20series%20by%201%20ect.%20How%20do%20you%20do%20this%3F%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1378239%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1378280%22%20slang%3D%22en-US%22%3ERe%3A%20Fill%20series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1378280%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F662562%22%20target%3D%22_blank%22%3E%40franrn%3C%2FA%3E%26nbsp%3B%2C%20try%20writing%201%20in%20a%20cell%20and%20then%202%20in%20cell%20below%20it.%20Then%20select%20both%20these%20cells%2C%20and%20then%20drag%20the%20handle%20(small%20green%20square)%20at%20bottom%20right%20of%20the%20selection%20rectangle.%20It%20should%20fill%20the%20series%201%2C2%2C3%2C4...%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%22amit_bhola_0-1589136663335.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190462i89BEBBE00665745A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22amit_bhola_0-1589136663335.png%22%20alt%3D%22amit_bhola_0-1589136663335.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Just want to start with 1 and add 1 to the next number so I have 1,2,3,4 and so on down the page how had is this. The old fill function did this fill series by 1 ect. How do you do this???

2 Replies
Highlighted

@franrn , try writing 1 in a cell and then 2 in cell below it. Then select both these cells, and then drag the handle (small green square) at bottom right of the selection rectangle. It should fill the series 1,2,3,4...

 

amit_bhola_0-1589136663335.png

 

Highlighted
Type in 1 in cell A1 and CTRL + Enter
Home > Fill > Series > check Column > In the stop value, type in number to fill up to I.e 100 > Enter

That will fill that series