Auto-Fill Table Cells

Auto-fill is useful when you want the data in a logical or repetitive order in the adjacent cells of a table. The data includes dates, sequential numbers, days of the week, months etc.

This feature is also useful when you want to repeat the formula of one cell to others.

To use Auto-fill feature:

  1. Select a cell.

    The fill handle appears in the lower right corner of the selected cell.

  2. Drag the fill handle in the direction that you want to fill the data.

    The cells in the row are auto-filled if you drag the handle horizontally. The cells in the column are auto-filled if you drag the handle vertically.