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???
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
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