Fill series

Command: Edit
Next selectFill
Next selectSeries
Shortcut: Ctrl+L

Description

Fills the selected range of cells in the spreadsheet with a series of numbers, characters, or dates. The content of the first cell in the selected range is used as the starting value for the series.

In the Fill series dialog box you enter:

  • Start value: Enter the start value for the series. The start value must be a number, character or properly formatted date.
  • Step value: Enter a positive or negative number to indicate the amount by which you want a series to increase or decrease.
  • Step unit (dates): Specify whether the series of dates will increase by days, weeks, months, or years. Available only when creating a date series.

Example for dates:

First enter a date in the spreadsheet and select the range for the series

Spreadsheet Fill series function

Select Fill series in the menu (or press Ctrl+L) and complete the dialog box:

Spreadsheet Fill series function

This is the result:

Spreadsheet Fill series function

See also