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
Click Fill series on the menu, or press Ctrl L, and complete the dialog box:
This is the result: