Enter the formula into the upper cell of the desired area. Storeys puts a copy of the formula from the source cell into the other selected cells. The cell references in the formula change to specify the relative position in each cell. Fill Right Use this menu command to easily fill adjacent cells with the same formula. Enter the formula into the most left cell of the desired area.
Storeys puts a copy of the formula from the source cell into the other selected cells.
The cell references in the formula change to specify the relative position in each cell. The copy , paste and fill features are especially useful in budgeting , accounting and in science. If you need more info , download spreadsheet Storeys and try out the attached examples and there is plenty information in the manual too. You might also want to have a look at the Storeys spreadsheet examples here or read the Version History . This page updated on 6.