Refer to the below screenshot.Īs fill handle identifies the pattern and accordingly fill the respective cells with that pattern. It will automatically fill all the cells until the end of the dataset.Place the mouse cursor on this square and double-click on the fill handle. This tiny cross is a versatile tool in the Excel suite that can be used for data entry, data transformation, and many other applications. Select both the cells as per the below screenshot.Īs we can see, there is a small square shown in the above screenshot rounded by red color called Fill Handle in Excel Fill Handle In Excel The fill handle in Excel allows you to avoid copying and pasting each value into cells and instead use patterns to fill out the information.Enter 1 in Cell A3 and enter 2 in Cell A4.For the above dataset, we have to fill the serial no record-wise.