Copying Formulas

From LibreOffice Help
Jump to: navigation, search

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 and texts to be automatically adjusted, then hold down the Ctrl key when dragging. Formulas, however, are always adjusted accordingly.


Related Topics

Addresses and References, Absolute and Relative