Excel Fill Handle

Created with Sketch.

Excel Fill Handle

The fill handle is a convenient Excel tool that is used to fill data with a specific pattern. You can extend a series of numbers, dates and text combinations to desired number of cells.

To use fill handle bring the mouse cursor at right bottom corner of the cell it will change into a + sign. Now left click on it and drag it downward to the desired range of cells.

Fill Handle in Excel

If you select one cell the value in the cell will be copied to other cells and if you choose multiple cells with specific pattern like difference between cells then the same pattern will be copied to other cells. See the image shown below.

Fill Handle in Excel 2

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This is a free online math calculator together with a variety of other free math calculatorsMaths calculators
+