# Fill Series

Automatically generate series with the options in this dialog. Determine direction, increment, time unit and series type.

рдХрд┐рд╕реА рд╢реНрд░реЗрдгреА рдХреЛ рднрд░рдиреЗ рд╕реЗ рдкрд╣рд▓реЗ, рдХрдХреНрд╖ рдХреНрд╖реЗрддреНрд░рд╕реАрдорд╛ рдЪреБрдиреЗрдВ.

To access this command...

Choose Sheet - Fill Cells - Series.

To automatically continue a series using the assumed completion rules, choose the AutoFill option after opening the Fill Series dialog.

## рджрд┐рд╢рд╛

рд╢реНрд░реЗрдгреА рддреИрдпрд╛рд░ рдХрд░рдиреЗ рдХреА рджрд┐рд╢рд╛ рдирд┐рд░реНрдзрд╛рд░рд┐рдд рдХрд░рддрд╛ рд╣реИ.

### рдиреАрдЪреЗ

Creates a downward series in the selected cell range for the column using the defined increment to the end value.

### рджрд╛рдпрд╛рдБ

Creates a series running from left to right within the selected cell range using the defined increment to the end value.

### рдКрдкрд░

Creates an upward series in the cell range of the column using the defined increment to the end value.

### рдмрд╛рдпрд╛рдБ

Creates a series running from right to left in the selected cell range using the defined increment to the end value.

## рд╢реНрд░реЗрдгреА рдХрд╝рд┐рд╕реНрдо

Defines the series type. Choose between Linear, Growth, Date and AutoFill.

### рд▓реАрдирд┐рдпрд░

Creates a linear number series using the defined increment and end value.

### рдмрдврд╝рдд

Creates a growth series using the defined increment and end value.

### рдбрд╛рдЯрд╛

Creates a date series using the defined increment and end date.

### рд╕реНрд╡рддрдГ рднрд░реЗрдВ

Forms a series directly in the sheet. The AutoFill function takes account of customized lists. For example, by entering January in the first cell, the series is completed using the list defined under - LibreOffice Calc - Sort Lists.

AutoFill tries to complete a value series by using a defined pattern. The series 1,3,5 is automatically completed with 7,9,11,13, and so on. Date and time series are completed accordingly; for example, after 01.01.99 and 15.01.99, an interval of 14 days is used.

Automatically Filling in Data Based on Adjacent Cells

## рд╕рдордп рдХреА рдЗрдХрд╛рдИ

In this area you can specify the desired unit of time. This area is only active if the Date option has been chosen in the Series type area.

### рджрд┐рди

Use the Date series type and this option to create a series using all seven days of the week. Unit of Increment is day.

### рд╕рдкреНрддрд╛рд╣ рдХреЗ рджрд┐рди

Use the Date series type and this option to create a series only using the five weekdays. Unit of Increment is day.

### рдорд╣реАрдирд╛

Use the Date series type and this option to form a series which unit of Increment is month.

### рд╡рд░реНрд╖

Use the Date series type and this option to create a series which unit of Increment is year.

## рдкреНрд░рд╛рд░рдВрдн рдореВрд▓реНрдп

Determines the start value for the series. Use numbers, dates or times.

## рдЕрдВрддрд┐рдо рдореВрд▓реНрдп

Determines the end value for the series. Use numbers, dates or times.

## рд╡реГрджреНрдзрд┐

The term "increment" denotes the amount by which a given value increases. Determines the value by which the series of the selected type increases by each step. Entries can only be made if the linear, growth or date series types have been selected.