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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |