Fill series

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

@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...




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