Resources
Formulas
- Click the Formulas tab
- Click in the cell where the formula needs to be
- Begin your formula with an equal (=) sign
- Use Cell References in the formula (to add what is in cell A1 to B1 the formula would be =A1+B1) Press enter after you have entered your formula
Autosum
The AutoSum function allows you to total all of the values in a range of cells.
- Click in the cell where the total needs to be.
- Click the AutoSum button on the Formula Bar
- Select the cells you would like to add by either highlighting or typing the beginning and ending cell like this =SUM(D2:D15) to add cells D2-D15
- Press enter and the sum will appear
Copy A Formula
Instead of typing each formula you can copy an existing formula
- Select the cell that contains the original formula
- Position the mouse pointer over the lower right corner of the cell until the black cross (+) appears.
- Drag the fill handle
over the cell(s) you would like the formula to copy into. - Release your mouse and the formulas will have copied.
Absolute Reference
Sometimes you want to copy a formula, but keep one of the cells the same every time. To do that you must use an absolute reference. Absolute reference cells have $ around the cell $A$1 is an example: in the formula =A1+$B$2 --B2 will always stay B2 no matter how many times you copy the formula to other areas.
Return to top