Using Fill Functions
When using the project spreadsheet or the Item Editing tab for a compound object in the spreadsheet view, you can use the fill functions to enter the same data from one cell into other cells. You can:
To enter the same cell data in multiple contiguous rows, use the Fill Down, Fill Up, or Fill All functions when a cell is selected. You can access these functions when a spreadsheet cell is selected by:
Selecting Fill from the Edit menu. Then click one of the three functions.
Right-clicking on the selected field and choosing one of the three functions.
To use the fill functions:
Select the cell that contains the text that you want to copy.
Select Fill from the Edit menu and then click Fill Down, Fill Up, or Fill All. Or, right-click on the cell and click Fill Up, Fill Down, or Fill All.
Note: Compound objects have an additional Fill Compound Object option available. Use this option to fill the same data in the selected field for all pages of the compound object.
You can copy the contents of a cell and paste it into other cells. You cannot copy more than one cell's contents at a time. You can paste into multiple cells. The same contents will be pasted into each selected cell.
To copy the contents of one cell and paste it into other cells:
Select the cell with the contents you want to copy.
Press Ctrl C.
Select the cells that you want to place the contents into using the mouse or the keyboard arrows and Shift key.
Press Ctrl V.