Operation Manual

Alternatively, you can use a shortcut to fill cells.
1) Select the cell containing the contents you want to copy or start the series from.
2) Move the cursor over the small square in the bottom right corner of the selected cell. The
cursor will change shape.
3) Click and drag in the direction you want the cells to be filled. If the original cell contained
text, then the text will automatically be copied. If the original cell contained a number, a
series will be created.
Figure 112: Using the Fill tool
Using a fill series
When you select a series fill from Edit > Fill > Series, the Fill Series dialog (Figure 113) opens.
Here you can select the type of series you want.
Figure 113: Fill Series dialog
• Direction – determines the direction of series creation.
– Down – creates a downward series in the selected cell range for the column using the
defined increment to the end value.
– Right – creates a series running from left to right within the selected cell range using the
defined increment to the end value.
– Up – creates an upward series in the cell range of the column using the defined
increment to the end value.
– Left – creates a series running from right to left in the selected cell range using the
defined increment to the end value.
138 | Getting Started with LibreOffice 5.0