This section describes how to enter sequences by dragging.
Microsoft® Excel
2003
You can enter both number and text sequences. The
sequences can be divided into natural and non-natural situations.
- To enter a natural sequence, do the following steps:
- Enter the value for the first cell.
- Hover the cursor to make it become a black cross.
- Drag the cross to enter the rest of the sequence.
For example, to enter the month names from January to December,
enter "Jan" or "January" in the first cell, and then drag the cursor
after it becomes a black cross. The rest of sequence is automatically
entered.
- To enter a non-natural sequence, do the following steps:
- Enter the least values that can include the calculation rules.
- Select the cells that were entered with values in the previous
step.
- Hover the cursor to make it become a cross.
- Drag the cross to enter the rest of the sequence.
For example, to enter odd numbers, enter "2" and "4" in the first
cell and the second cell, then select the two cells and drag the cursor
after it becomes a cross. The rest of this sequence is automatically
entered.
IBM® Lotus® Symphony™ Spreadsheets
You
can enter both number and text sequences. The sequences can be divided
into natural and non-natural situations.
- To enter a natural sequence, do the following steps:
- Enter the value for the first cell.
- Hover the cursor to make it become a cross.
- Drag the cross to enter the rest of the sequence.
For example, to enter the month names from January to December,
enter "Jan" or "January" in the first cell, and then drag the cursor
after it becomes a cross. The rest of sequence is automatically entered.
- To enter a non-natural sequence, do the following steps:
- Enter the least values that can include the calculation rules.
- Select the cells that were entered with values in the previous
step.
- Hover the cursor to make it become a cross.
- Drag the cross to enter the rest of the sequence.
For example, to enter odd numbers, enter "2" and "4" in the first
cell and the second cell, then select the two cells and drag the cursor
after it becomes a cross. The rest of this sequence is automatically
entered.