Excel 2003:Subtraction, Multiplication, and Division(Point Method)

You can put in a (minus) for subtraction, (asterisk) * for multiplication, and (slash) / for division. As you become more capable we'll, build some nifty formulas – using these features.

Point Method:

Move to cell C9 again and click-on it. We'll now add the numbers a second way. Tap the Delete key on the keyboard to delete the current formula.
First, tap the = and then POINT (move) the cursor over cell C6 using the mouse, tap the left mouse button on cell C6 (you will see a marquee box go around the cell).


Now tap a + and move cursor to C7, tap the left mouse button, and tap another + and move the cursor to C8 and tap the left mouse button (notice how as you " + and point " the addition formula is being built in cell C9), now tap Enter. The same formula can be built using the arrow movement keys on the keyboard (except that you don’t have to click-on each cell as the cell is marked - as you move the arrows). Notice, as you are entering the cell addresses, that as you place another + in the formula, that the cursor “returns” to cell C9. Also notice, as you point to each cell that it is highlighted by a “marquee box.” This “tells” you what cell you’ve pointed to. Pretty neat!

This method is good when you need to move to numbers that are spread out all over the place. Some people like it best and use it all the time it's your choice.