Excel Fill Down
-
Most users of Microsoft Excel are aware of the fill-down handle, allowing you to click and drag on the small square at the bottom right-hand corner of a cell to fill the contents of subsequent cells with the same data or data fitting the pattern of the selected cells. If you would like a quicker way to fill-down, then simply double-click on the fill-down handle (small square) and it will automatically fill-down. Be aware, in order for this to work there must be data in other columns as Excel will determine where that data ends and stop the fill-down at that point.
Leave a Comment