Friday, 21 February 2014

How to use Fill Handle in Excel 2010

Excel provides auto fill options that will automatically continue a series of data based on an established pattern. The fill handle is a small black square in the lower-right corner of the selected cell. To use fill handle do the following:

1. Hover the cursor over the lower-right corner of the cell until it turns into [+].
2. Click and drag the handle from cells that contain data to the cells you want to fill with new data.
The diagram below shows an example:

Excel automatically completes the series as far as you take the fill handle.
You can choose how the selection is filled by using the auto fill options as shown above.