Inserting a series

You can copy cell values into other cells and, for example, increment them at the same time (the value is changed according to mathematical rules).

Enter a value in a cell.
Click the black handle at the bottom right corner of the cell and drag it in the downwards or across to select the cells into which to copy the value.
Select Insert > Series.
Specify the type of series, the amount by which it should increment and the final value.

Example

To create a list, counting in fives from zero to one hundred, enter 0 in a cell. Drag the cell handle downwards to select 20 rows. Select Insert > Series and select Arithmetical as the type. Set 5 as the Increment and 100 as the final value.

Series options

The Type section: Here you specify how the values of the series or the dates are increased.
Arithmetical: The values of the series are increased by the increment.
Geometrical: Each value is the result of multiplying the previous value by the specified increment. For example, 5 with an increment of 2 produces this series: 5,10,20,40,80....
Date: Here you can create a series that is based on the date. Select a time unit and the increment by which it should be increased.
Time Unit: The Time units are Day, Week-day, Month and Year. If you select Weekday, Saturdays and Sundays are not displayed.
Direction: Select Rows to create the series in rows. Select Columns to create the series in columns.