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 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.
Procedure
- Open the project that has the task values to duplicate, and click Workflow.
- Shift+click in the first cell, or click the cell, to select it.
-
Move the cursor to the last cell you want to include, then
Shift+click in this cell. You can also drag the cursor to
the destination cell to include all cells from the source cell.
The range of cells you selected is highlighted.
Note: You must select a continuous range of cells, rather than selecting multiple, disconnected cells. -
Click Tools and select one of the following options:
- - Copies the values in the top-most selected cell (or cells) to all the other selected cells, including the bottom-most.
- - Copies the values in the bottom-most selected cell (or cells) to all the other selected cells, including the top-most.