Filling data into a range of cells

About this task

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. 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 in the first row into the remaining nine rows, you use Shift+click to select the cells in these 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.
    • 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.