In some table format display columns, you can use the Fill Down feature to quickly enter the same text in successive rows.
- To copy text from one row to successive rows within a column, select the row containing the text you want to copy and the rows you want to copy the text to, then choose Edit, Fill Down.
The following provides an example:
Using the Fill Down function, you can quickly copy the activity name Design external interfaces from activity A1350 to activities A1840, A1850, and A1860.
Tips
- The rows you select to copy to can be next to each other as shown in the preceding graphic, or not directly adjacent, as shown in the following graphic.
- The Fill Down feature can also be used to copy text to rows above the first row you select. The text will always be copied from the first row you select to the subsequent rows you select. Select multiple rows by pressing the Ctrl key as you click each row you want to copy to.
- You can also copy the values in a range of cells from one row of a spreadsheet to another part of the same row, or to a range of cells on another row.