IBM Lotus Symphony


Automatically filling a sequence of cells

Use this procedure to automatically increment data as you fill down a column or across a row.

Automatic fill only increments data that IBM Lotus Symphony recognizes, such as numbers, dates and cell references. If Lotus Symphony does not recognize data, automatic fill duplicates the data exactly. However, you can create sort lists that contain lists of data that Lotus Symphony can use. Lotus Symphony will recognize and automatically increment. If you just want to copy the range without changing the values, press the Ctrl key while dragging.

Here are a few examples of how the automatic fill sequence works:
  • The sequence 1, 2 becomes 1, 2, 3, 4, and so on
  • The sequence 1, 3 becomes 1, 3, 5, 7, and so on
  • The cell content "Quarter 1" becomes Quarter 1, Quarter 2, Quarter 3, and so on
  1. (Optional) To create a sort list, choose File > Preferences > Symphony > Lotus Symphony Spreadsheets > Sort Lists.
  2. Select the cell range whose existing contents you want to extend to more cells, and then release the mouse button.
  3. Move the mouse pointer on top of the automatic fill handle in the lower right of the selected cell.
  4. The mouse cursor turns into a plus sign (+) when you click the mouse button.
  5. Click and hold down the left mouse button on the automatic fill handle, and drag in the desired direction of the fill, selecting all the cells that you want to contain data.

Product Feedback | Additional Documentation | Trademarks