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.
Procedure
- Open the project that has the task values to duplicate, and click the Workflow tab.
- Click Edit.
- Shift+click in the first cell to select it.
- 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. -
Click Tools () and select one of the following options:
Option Description 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. - Click Save.