If, for example, there is a blank cell in column B (say cell B6), then this auto-fill double click would only apply the formula till cell C5 In our example, the formula would be applied till cell C15įor this to work, there shouldn’t be data in the adjacent column and there should not be any blank cells in it. The above steps would automatically fill the entire column till the cell where you have the data in the adjacent column. You will notice that the cursor changes to a plus sign (this is called the autofill handle) Place the cursor over the small green square.With the cell selected, you will see a small green square at the bottom-right part of the selection.Suppose you have the dataset as shown below, where want to calculate the commission for each sales rep in Column C (where the commission would be 15% of the sale value in column B).īelow is the way to apply this formula to the entire column C: One of the easiest ways to apply a formula to an entire column is by using this simple mouse double-click trick. Adding the Fill Down in the Quick Access Toolbarīy Double-Clicking on the AutoFill Handle.Using the Fill Down Option (it’s in the ribbon).By Double-Clicking on the AutoFill Handle.
