Leading the way in Microsoft Office Development

Step 1 - Copying Values

If you select a single cell containing a number and drag the fill handle the value will be copied into the adjacent cells.

This is the default when you use AutoFill on a single cell containing a number.

If you select more than one cell and drag the fill handle then the default is for the series to be continued.

Alternatively you can enter the value in the first cell, highlight the whole range and press (Ctrl + D) to copy the value down.

You can also use the shortcut key (Ctrl + R) to copy a value across to the right.

Step 2 - Copying Text

You can repeat text as well as numbers.

Select the cells "B2:B4" and drag the fill handle down using the left mouse button.

You will notice that a yellow tool tip should display the value that will be copied into the subsequent cell as you drag.

Step 3 - Copying Text (with Numbers)

Step 4 - Copying Empty Cells

You can also clear data within a selection by dragging the fill handle up or to the left within the selection

The data to be cleared appears with a grey dotted border as you drag the fill handle.

This can be used to remove formatted and as an alternative for removing data.

When you drag an empty cell over a cell that contains data you might be prompted asking you whether you want to overwrite the existing cells.

This option is controlled from (Tools > Options)(Edit tab, Alert before overwriting cells).

Step 5 - Things to Remember

Whenever you use the fill handle a yellow tool tip will appear to indicate the value that will be placed in the last cell.