Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Copying Formulae

There are various ways to copy a formula. One suggested method is:

  1. Select the cell containing the formula.

  2. Choose Edit - Copy, or press Ctrl+C to copy it.

  3. Select the cell into which you want the formula to be copied.

  4. Choose Edit - Paste, or press Ctrl +V. The formula will be positioned in the new cell.

If you want to copy a formula into multiple cells, there is a quick and easy way to copy into adjacent cell areas:

  1. Select the cell containing the formula.

  2. Position the mouse on the bottom right of the highlighted border of the cell, and continue holding down the mouse button until the pointer changes to a cross-hair symbol.

  3. With the mouse button pressed, drag it down or to the right over all the cells into which you want to copy the formula.

  4. When you release the mouse button, the formula will be copied into the cells and automatically adjusted.

If you do not want values to be automatically adjusted, then hold down the Ctrl key when dragging. Formulae, however, are always adjusted accordingly.