Formulu kopēšana

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

1. Atlasiet šūnu, saturošu formulu.

2. Izvēlieties Rediģēt - Kopēt vai nospiediet+C, lai kopētu to.

3. Atlasiet šūnu, kurā jūs vēlaties lai tiktu iekopēta formula.

4. Choose Edit - Paste, or press +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. Atlasiet šūnu, saturošu formulu.

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 key when dragging. Formulas, however, are always adjusted accordingly.