Copy Adjacent Cells and Formulas
Copying adjacent cells is when you copy the cell's
contents into the cells below it or next to it. When you copy a formula,
Excel will change it to fit your specific row or
column.
Steps (copying adjacent cells):
1) Put your mouse over the fill handle and it will automatically
change to a cross hair looking like this (+).
2) Click and drag the fill handle to the adjacent
cells (up, down, left, or right). It will automatically copy your cells
contents to the adjacent cells.
3) If your cell has a date, time or a combination of a text and a
number, then it will copy the cells to consecutive dates, times and
numbers. (look below).
Only cells A1, A2, and A3 were inserted. The rest
were automatically inserted when I clicked on the fill handle and
dragged to adjacent cells.
Steps (copying formulas):
1) Click on the cell with the formula, and then click on the
fill handle and drag. This will automatically copy the formula and
change it relative to the cells you are copying it to.
Example: A1 contains the number 4 and A2 contains the number 5.
The formula in A3 adds both cells A1 and A2 together. B1 contains the
number 6 and B2 contains the number 7. When I clicked on the fill handle
in A3 and dragged it to B3, the formula inserted in B3 was =B1+B2
instead of the original =A1+A2.
