
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:
- Select a cell.
The fill handle appears in the
lower right corner of the selected cell.
- 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.