Filling data into a range of cells

To reduce data entry time, you can copy data that is entered for one or more tasks and supply it for another task or tasks by using Tools options.

About this task

For example, you have 10 consecutive tasks with the same values for target start, target end, target duration, and target effort. You enter the data for the first task. To copy the values that are in the first row into the remaining nine rows, Shift+click to select the cells in those four columns for all 10 tasks. Then, use the Fill Down option.

You can also copy the data in one or more adjacent cells and paste it into one or more adjacent cells. See Workflow copy and paste.

Note: The options for working with a range of cells apply to adjoining cells only: use Shift+click to select the cells.

Procedure

  1. Open the projectAdvanced List, On-demand Campaign, or Corporate Campaign that has the task values to duplicate, and click the Workflow tab.
  2. Click Edit.
  3. Shift+click in the first cell to select it.
  4. Move the cursor to the last cell you want to include, then Shift+click in this cell.

    The range of cells you selected is highlighted.

    Note: You must select a continuous range of cells, rather than selecting multiple, disconnected cells.
  5. Click Tools (Page with clipboard and plus sign imageBox with handle image) and select one of the following options:
    OptionDescription
    Fill Down Copies the values in the top-most selected cell (or cells) to all the other selected cells, including the bottom-most.
    Fill Up Copies the values in the bottom-most selected cell (or cells) to all the other selected cells, including the top-most.
  6. Click Save.