Autofilling Table Cells
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
m
the Fill handle (a small circle in the cell’s lower-right corner) over the cells into which
you want to paste.
Any data, cell format, formula, or fill associated with the selected cell is pasted, but
comments aren’t 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,
m
select two or more adjacent cells and choose one of the following:
Insert > Fill > Fill Right: Assigns selected cells the value in the leftmost selected cell.
Insert > Fill > Fill Left: Assigns selected cells the value in the rightmost selected cell.
Insert > Fill > Fill Up: Assigns selected cells the value in the bottommost selected cell.
Insert > Fill > Fill Down: Assigns selected cells the value in the topmost selected cell.
Any data, cell format, formula, or fill associated with the selected cell is pasted, but
comments aren’t 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
m
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.
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.