The intervals in the relative row or column references need not be of the same size. Fill When working in the traditional 2D-area you can fill down and fill right just as you are used to do it in from other spreadsheets. It is a neat feature that helps a lot when creating large spreadsheet models. Fill down Use this menu command to easily fill adjacent cells with the same formula. 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.