IBM Lotus Symphony
|
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.
First select the range in the table that you want to fill.
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.
![]() |
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:
Enter a date, such as "1/1/03", into a cell (without the quotation marks).
Select this cell and the 11 cells below it.
Choose Edit - Fill - Sequence.
In the dialog, select Month under Time unit. Click OK.
The first day of each month automatically appears in the selected cells.