Fill Down command

Use this command the shortcut menu to copy the description, quantity, unit, or notes from an overline or an item to selected items below the overline.

Shortcut menus provide access to commands that you may need to accomplish a particular task.

To open a shortcut menu, point to something in a Sage Estimating (SQL) window, and then right-click it. The available commands vary based on where you are pointing.

To copy a value from a source cell to contiguous selected cells below:

  1. Select the Description, Quantity, Unit, or Notes cell you want to copy from, and then drag your mouse down to select the item and overline cells in the same column that you want to copy to.
  2. Right-click your selection, and then click Fill Down.

Note: If the estimate uses the Automatically calculate overline quantities option, and:

  • The target cell is in an item row, only the absolute quantity is copied to that cell, regardless of whether the source cell is aggregated or a lump sum.
  • The target cell is in an overline row, if the source cell is aggregated, the target cell will be aggregated, even if the target cell was initially aggregated.

If the initial cell contains a lump sum amount, all the cells you are copying to, including overlines, are updated with the fixed amount.