The to a higher place steps would automatically fill the entire column till the cell where you have the data in the next column. You lot volition discover that the cursor changes to a plus sign (this is called the autofill handle)
Identify the cursor over the small green square.With the cell selected, you lot volition see a small dark-green square at the bottom-right role of the selection.In prison cell A2, enter the formula: =B2*15%.The formula for this would exist: =B2*xv%īeneath is the way to utilise this formula to the unabridged cavalcade C: Suppose yous have the dataset equally shown below, where want to summate the commission for each sales rep in Column C (where the commission would exist 15% of the sale value in column B). One of the easiest means to apply a formula to an unabridged column is by using this uncomplicated mouse double-click trick. Past Double-Clicking on the AutoFill Handle Adding the Fill Downwards in the Quick Admission Toolbar.Using the Fill Down Option (it’southward in the ribbon).By Double-Clicking on the AutoFill Handle.
0 kommentar(er)
