IBM Lotus Symphony


Automatically Calculating Sequence

  1. Enter a number in a cell.
  2. With the mouse, drag the bottom right corner of the cell downwards.
  3. When you release the mouse button, the cells selected in this manner are filled with numbers. The number you entered is increased by 1 in each case.

If you have selected two or more adjacent cells, that contain different numbers, and you drag these together, any recognizable arithmetic pattern of the numbers is continued.

An example: If A1 contains the number 1 and A2 the number 3, then joint copying of the two cells by dragging downwards causes the sequence to continue with 5, 7, 9, 11 and so on.

  1. First select the range in the table that you want to fill.

  2. In the dialog, which you can open by choosing Edit - Fill - Sequence, select the type of sequence. For example, select 2 as the starting value, 2 as the increment and Growth as the Sequence type . The result in this case is a list of the powers of 2.

Table sheet with the dialog Fill Sequence

You can also automatically fill in sequence of dates. For example, to insert the first date of each month of the year as row headers:

  1. Enter a date, such as "1/1/03", into a cell (without the quotation marks).

  2. Select this cell and the 11 cells below it.

  3. Choose Edit - Fill - Sequence.

  4. In the dialog, select Month under Time unit. Click OK.

    The first day of each month automatically appears in the selected cells.


Product Feedback | Additional Documentation | Trademarks