With autofilling you can use the content in one or more cells to automatically add values to adjacent cells.

Here are ways to autofill table cells:
  • To paste the content and fill of a cell into adjacent cells, select the cell and then drag the Fill handle (a tiny circle in its lower-right corner) over the cells into which you want to paste.

    When you place the pointer over the Fill handle, it appears as a large plus sign (+), indicating that you can begin to drag across the cells you want to fill. Any data, cell format, formula, or fills associated with the selected cell are pasted. If any target cell contains data, autofilling overwrites that data with the value you're repeating.

  • To paste the content and fill of a cell into one or more cells in the same row or column, select two or more adjacent cells and choose one of the following.

    • Format > Table > Fill > Fill Right:  
      Assigns selected cells the value that resides in the leftmost selected cell.
    • Format > Table > Fill Left:  
      Assigns selected cells the value that resides in the rightmost selected cell.
    • Format > Table > Fill Up:  
      Assigns selected cells the value that resides in the bottommost selected cell.
    • Format > Table > Fill Down:  
      Assigns selected cells the value that resides in the topmost selected cell.

    Any data, cell format, formula, or fills associated with the selected cell are pasted. If any target cell contains data, autofilling overwrites that data with the value you're repeating.

  • You can also add values to cells based on value patterns. For example, if a cell contains a day of the week or a month, you can select the cell and then drag to the right or down to add the next day of the week or month to the adjacent cell, using the fill options described above.

    To create new values based on numeric patterns, select two or more cells before dragging. For example, if two selected cells contain 1 and 2, the values 3 and 4 are added when you drag through the adjacent two cells. And if two selected cells contain 1 and 4, the values 7 and 10 are added when you drag through the adjacent two cells (values are incremented by 3).

    Autofilling doesn't set up an ongoing relationship among cells in the group. After autofilling, you can change the cells independently of each other.

For detailed information about how to use the hundreds of iWork functions, choose Help > Formulas and Functions Help, or go to Formulas and Functions Help on the web.

Was this page helpful? Send feedback.