Fill series

Copper Contributor

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

@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

 

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