Forum Discussion
Fill series
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
- 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 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...
