SPREADSHEETS

Using the Fill Handle to Copy Formulas/Functions

The fill handle, located in the lower-right corner of a cell, is a useful tool for duplicating formulas and functions to other cells. This will save time because reentering the formula or function for each cell is not needed. Once the formula or function for a particular cell has been entered, all you have to do is drag the fill handle over the other cells in which you want the same formula or function to occur. Look at the graphics below to get an idea of how this works.