Often I have a need to keep part of the formula the same on an excel sheet and this can easily be done using the “$” sign in front of the column letter and/or the cell number. For instance, a formula for running total between cell F4 and F10 is SUM($F$4:$F10). The formula without the “$” sign is functionally the exact equivalent but when using the autofilling handle to drag the formula down a column of cells the cell reference part labeled with “$” sign does not change. Dragging the formula SUM($F$4:$F10) down will get you SUM($F$4:$F11) at the cell below and SUM($F$4:$F12) and so on.