Filling Data Blocks

You can highlight blocks of accounts and periods in a data grid, and modify or enter data in all the highlighted cells simultaneously. The fill value is taken from the upper left corner of the selected area. If the upper left corner is not an input cell, the Fill function has no effect.

  To fill data blocks:

  1. From a data grid, highlight a cell or block of cells that contains the data to use for other cells:

    • To highlight a row, select the dimension heading to the left of the row.

    • To highlight a column, select the dimension heading at the top of the column.

    • To highlight a block of cells, select a cell, and drag the cursor until all desired cells are highlighted.

  2. Select the cell or block of cells into which to paste the data.

  3. Right-click and select Fill.

The system fills the highlighted input cells only. If a highlighted cell is read-only, it is skipped.