960 Views 1 Reply Latest reply: Feb 11, 2011 1:21 PM by Jerrold Green1
You would search the User Guide for "Fill".
From the '09 User Guide: (I'm too lazy to get the '08 guide)
"You can also add values to cells based on value patterns. For example, if a cell contains a day of the week or a month, you can select the cell and then drag to the right or down to add the next day of the week or month to the adjacent cell.
To create new values based on numeric patterns, select two or more cells before dragging. For example, if two selected cells contain 1 and 2, the values 3 and 4 are added when you drag through the adjacent two cells. And if two selected cells contain 1 and 4, the values 7 and 10 are added when you drag through the adjacent two cells (values are incremented by 3).
Autofilling doesn’t set up an ongoing relationship among cells in the group. After autofilling, you can change the cells independently of each other."
With numeric input, you must manually enter the first two values in the sequence, select both, and drag to continue the sequence. With other data types you can drag a selection of one if you want incremental values or two if you want steps other than unity.