You will notice that the cursor changes to a plus sign (this is called the autofill handle) 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.
