IBM Lotus Symphony


Entering sequences by dragging

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:
    1. Enter the value for the first cell.
    2. Hover the cursor to make it become a black cross.
    3. 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:
    1. Enter the least values that can include the calculation rules.
    2. Select the cells that were entered with values in the previous step.
    3. Hover the cursor to make it become a cross.
    4. 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:
    1. Enter the value for the first cell.
    2. Hover the cursor to make it become a cross.
    3. 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:
    1. Enter the least values that can include the calculation rules.
    2. Select the cells that were entered with values in the previous step.
    3. Hover the cursor to make it become a cross.
    4. 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.

Product Feedback | Additional Documentation | Trademarks