Operation Manual

Using the Fill tool
The Calc Fill tool is used to duplicate existing content or create a series in a range of cells in your
spreadsheet (Figure 109).
1) Select the cell containing the contents you want to copy or start the series from.
2) Drag the mouse in any direction or hold down the Shift key and click in the last cell you
want to fill.
3) Go to Edit > Fill on the main menu bar and select the direction in which you want to copy
or create data (Up, Down, Left or Right) or Series from the context menu.
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 109: Using the Fill tool
Figure 110: Fill Series dialog
Using a fill series
When you select a series fill from Edit > Fill > Series, the Fill Series dialog (Figure 110) opens
allowing you to select the type of series you want.
• 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.
134 | Getting Started with LibreOffice 4.0