Incrementing Large Ranges

S

Steve in S.F.

I know that you can increment values in a column by entering a few values,
selecting them and then dragging the lower-right edge down the column. But
what if you want to do this for thousands of rows?

Is there some shortcut or function that you can use to get say rows 1 to
5,000 incremented by 1 each?

Thanks,

Steve
 
T

Teethless mama

enter the 1st number in row 1 and highlight that number
Edit > Fill > Series > Series in select Columns > Step Value: 1 > Stop
value: 5000 > OK
 
Top