You can often save time by copying a formula from one cell to another.
To do this, activate the cell whose formula you wish to copy. Then select Copy either from the toolbar or the Edit menu, or by right clicking your mouse.
Next, click on the cell to which you wish to copy the formula, and select Paste either from the toolbar or the Edit menu, or by right clicking your mouse. The formula is copied into the destination cell.
However, you may notice that the formula has been altered slightly. This is because Spreadsheet automatically adjusts the cell addresses in the formula so that they work logically in the new location.
To give an example, let’s say you entered the formula B8*C8 in cell D8. If you then copied it to cell D9, Spreadsheet would turn it into B9*C9, and in cell D10 it would become B10*C10.
If you do not want the cell addresses to be adjusted in this way, you need to specify them as absolute addresses.
See: