Using autofill to fill a range

You can drag to automatically fill a range with a sequence of data. The range is filled based on the data entered in the cell or range.

When you automatically fill a range, the value in the cell that you drag is incremented or decremented by 1 in each subsequent cell in the column or row. Values in a range are extended according to whatever arithmetic pattern exists in the range. For example, if you drag a range where the values in cells increment by 2, in each new cell that you fill the value also increments by 2.

To autofill a range:

  1. Select the cell or range containing the data that you want to base the sequence on.
  2. Drag the black square at the end corner of the cell or range, as follows:
    • To fill a column with values that increment the values in the original cell or range, drag the square down.
    • To fill a column with values that decrement the values in the original cell or range, drag the square up.
    • To fill a row with values that increment the values in the original cell or range, drag the square to the right.
    • To fill a row with values that decrement the values in the original cell or range, drag the square to the left.
    Tip: To delete the contents of a selected cell or range, drag the black square to the inside of the cell or range.

After completing the steps, you see the following results:




Trademarks | IBM Connections wiki