Calc Guide

Figure 24: Using the Fill tool
Using a fill series
A more complex use of the Fill tool is to use a fill series. The default
lists are for the full and abbreviated days of the week and the months
of the year, but you can create your own lists as well.
To add a fill series to a spreadsheet, select the cells to fill, choose Edit
> Fill > Series. In the Fill Series dialog, select AutoFill as the Series
type, and enter as the Start value an item from any defined series. The
selected cells then fill in the other items on the list sequentially,
repeating from the top of the list when they reach the end of the list.
Figure 25: Specifying the start of a fill series (result is in Figure 26)
46 OpenOffice.org 3.x Calc Guide