Instead of retyping the formula for each cell, the Fill Handle can be used to copy the formula created in D2 to D3:D6 in order to complete the table.ġ. The same formula is needed for cells D3:D6 (highlighted in yellow in the screenshot above). The formula as displayed in the Formula Bar above is: =B2*C2. In this example, the formula entered in cell D2 multiplies the cost price in B2 with the number of units in C2 to give the total cost. The Fill Handle can also be used to copy formulas to adjacent cells. You may even have already come across it and used it for copying down numbers, words or even series such as the days of the week.
The Fill Handle is a wonderful hidden gem in Excel. Test your Excel skills with the corresponding FREE Online Multiple ChoiceĮxcel Copying Formulas and using Relative and Absolute Cell References Test So does knowing how to change the formula to its actual value. Copying formulas using the fill handle saves a lot of time. To get the math correct every time you have to understand Absolute and Relative cell references when creating, copying and moving formulas. * Absolute and Relative References in Excel & Absolute Cell References Tutorial Free Online Microsoft Excel 2010 Tutorial – Formulas & Functions in Excel Copying Formulas in Excel & using Relative & Absolute Cell References Tutorial – Free Online Microsoft Excel 2010 Tutorial Copying Formulas in Excel & using Relative
