Page 101 - Ms Excel Note and Workbook
P. 101
MICROSOFT EXCEL NOTE AND WORKBOOK
3. Press Enter on your keyboard. The formula will be calculated, and the result will be displayed in
the cell.
4. Locate the fill handle in the bottom-right corner of the desired cell. In our example, we'll locate
the fill handle for cell D4.
5. Click and drag the fill handle over the cells you want to fill. In our example, we'll select
cells D5:D13.
6. Release the mouse. The formula will be copied to the selected cells with relative
references, displaying the result in each cell.
TIP
You can double-click the
filled cells to check their
formulas for accuracy
92 | P a g e
