This fills a selected range with values such as numbers, dates, formulas, built‑in lists (day/month names), or custom lists. The series type is determined automatically based on the first one or two cells.

If the initial cells do not match any known series type, a simple copy operation is performed. If the first two cells are separated by empty cells, that gap is repeated throughout the series.

• Built‑in list items (day/month names) may appear as substrings inside cell text. Example: “departure on Monday” → “departure on Tuesday”, etc.
• Custom list items may also appear as substrings, but must be inserted explicitly via the list name using the Fill button.

If only one element is provided, GS-Calc uses default increments:

• Numbers: +1
• Time values: +1 hour
• Date values: +1 day
• Formulas: +1 column/row reference

Relative and absolute references may be adjusted depending on settings in Settings > Options.

Click the Fill button and choose a list, or use the Manage dialog and click Insert.

If a specific custom list is chosen:

• Custom list items may appear as substrings, but must be inserted explicitly via the list name.
• The target range does not need initial elements; if empty, the series starts from the first list item.

This allows defining any type of series, including those referencing other workbook resources.

Define a formula for the first item. GS-Calc updates references automatically to generate subsequent values. The formula may use the previous value or compute each value directly based on its position.

Used formulas are saved in a “recently used” list and references are updated automatically when reused elsewhere.

Several popular distribution types are available. For uniform distribution, you may generate a series of randomly selected custom list items.

Built‑in series of month names (system‑dependent):

Series with embedded custom list items:

Built‑in 2D numeric series:

Series of numbers and dates:

Series of formulas:

Series with elements placed every n‑th cell:

Inserting many series at once: