Operation Manual

Figure 113: AutoCorrect dialog
Deactivating automatic changes
Some AutoCorrect settings are applied when you press the spacebar after you enter data. To turn
off or on Calc AutoCorrect, go to Tools on the Menu bar and deselect or select AutoInput.
Speeding up data entry
Entering data into a spreadsheet can be very labor-intensive, but Calc provides several tools for
removing some of the drudgery from input.
The most basic ability is to drop and drag the contents of one cell to another with a mouse. Many
people also find AutoInput helpful. Calc also includes several other tools for automating input,
especially of repetitive material. They include the fill tool, selection lists, and the ability to input
information into multiple sheets of the same document.
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 114).
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 Sheet > Fill Cells on the Menu bar and select the direction in which you want to copy
or create data (Up, Down, Left or Right) or Series and Random Number... from the
submenu.
140 | Getting Started with LibreOffice 5.1