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.

Copyright © 2000-2017 StatsDirect Limited, all rights reserved. Download a free trial here.