Fill Series

 

Menu location: Data_Fill Series.

 

This function fills a series of rows in a worksheet with numbers according to a formula that you specify.

 

The default formula is VX+1 with a starting value of 1, which will give a sequence of numbers from 1 to the length of series that you specify. A formula of VX+10 would give a series of integers spaced at 10, i.e. 10, 20 30, 40 etc. Complex non-linear formulae can be used; see calculator for a list of functions that you can use in a formula.