Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu

Fill series

Next selectFill
Next selectSeries
Shortcut:Ctrl L


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:

Example for dates:

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

Fill series

Click Fill series on the menu, or press Ctrl L, and complete the dialog box:

Fill series

This is the result:

Fill series

See also